# Find PostgreSQL Performance Discussions on Hacker News

**Use case:** 

Returns recent Hacker News stories and comments about PostgreSQL performance, with text and timestamps to help database engineers and infrastructure teams track tuning ideas and recurring problems. Change searchQueries to explore another topic, or dateRangeFrom to set the earliest date.

## Input

```json
{
  "mode": "search",
  "itemIds": [],
  "usernames": [],
  "searchQueries": [
    "PostgreSQL performance"
  ],
  "searchSort": "date",
  "contentTypes": [
    "story",
    "comment"
  ],
  "exhaustiveSearch": false,
  "dateRangeFrom": "2026-10-01",
  "domainAllowlist": [],
  "domainBlocklist": [],
  "excludeDeadOrDeleted": true,
  "commentAuthorFilter": [],
  "commentSort": "rank",
  "maxComments": 0,
  "maxDepth": 5,
  "enableCommentHierarchy": false,
  "includeSubmissions": false,
  "submissionTypes": "all",
  "hiringMonths": 1,
  "hiringThreadIds": [],
  "hiringKeywords": [],
  "remoteOnly": false,
  "maxItems": 20,
  "includeAuthorProfiles": false,
  "startUrls": []
}
```

## Output

```json
{
  "recordType": {
    "label": "Record type"
  },
  "title": {
    "label": "Title"
  },
  "company": {
    "label": "Company"
  },
  "role": {
    "label": "Role"
  },
  "url": {
    "label": "Url"
  },
  "score": {
    "label": "Score"
  },
  "author": {
    "label": "Author"
  },
  "numComments": {
    "label": "Num comments"
  },
  "createdAt": {
    "label": "Created at"
  },
  "domain": {
    "label": "Domain"
  },
  "frontPageDate": {
    "label": "Front page date"
  }
}
```

## How it works

### 1. Sign up on Apify or log in

The Hacker News Story, Comment & Karma Scraper Actor is ready to run with the inputs already set for "Find PostgreSQL Performance Discussions on Hacker News". [Sign up or log in](https://console.apify.com/create-task-from-example/X5m7hsheuhfZdyunF) and you'll land in Apify Console with a copy of this exact task.

### 2. Start the "Find PostgreSQL Performance Discussions on Hacker News" task

The Hacker News Story, Comment & Karma Scraper Actor will start running based on the input automatically. You can also change all the input fields, like mode, item ids (mode=item), and more, to match your specific use case.

### 3. Receive the "Find PostgreSQL Performance Discussions on Hacker News" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as record type, title, company, and more.

### 4. Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also [run the "Find PostgreSQL Performance Discussions on Hacker News" task via API](https://apify.com/dataspryva/hacker-news-story-comment-and-karma-scraper.md).

## FAQ

### How do I find recent PostgreSQL performance discussions on Hacker News?

The PostgreSQL discussion search task searches Hacker News stories and comments for “PostgreSQL performance,” sorted newest first, from October 1, 2026 onward.

### What PostgreSQL performance data does a Hacker News search return?

Each result in the PostgreSQL discussion search task can include a title, text, author, score, timestamp, and link; comment results may also include the related story title and URL.

### How can I search Hacker News for another technology topic?

Change the search phrase in the PostgreSQL discussion search task to explore another topic; each query runs independently and results are merged without duplicates.

### Can I search Hacker News comments as well as stories?

The PostgreSQL discussion search task includes both stories and comments, as selected for this run.

### How many Hacker News results can this search return?

The PostgreSQL discussion search task has a 20-result cap across records; nested comments count toward the cap when collected.

### Can I run a Hacker News PostgreSQL search on a schedule or through an API?

You can run the PostgreSQL discussion search task on an Apify schedule, through the Apify API, or with integrations such as Zapier, Make, and n8n.

## About this Actor

This example demonstrates how to use [Hacker News Story, Comment & Karma Scraper](https://apify.com/dataspryva/hacker-news-story-comment-and-karma-scraper.md) with a specific input configuration. Visit the [Actor detail page](https://apify.com/dataspryva/hacker-news-story-comment-and-karma-scraper.md) to learn more, explore other use cases, and run it yourself.


## How to integrate an Actor?

This Task's input is already configured above. Use it as-is rather than inventing a new one.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For full API examples (JavaScript, Python, CLI, MCP, OpenAPI), see this Task's Actor page: https://apify.com/dataspryva/hacker-news-story-comment-and-karma-scraper.md

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).