Postgres Pro
Downloads
Home   >   mailing lists

Re: slow query - Mailing list pgsql-performance

From Tom Lane
Subject Re: slow query
Date
Msg-id 2083.1423662288@sss.pgh.pa.us
Whole thread Raw
In response to slow query  (Sathish Nelson <satson.csc17@gmail.com>)
List pgsql-performance
Tree view 
Sathish Nelson <satson.csc17@gmail.com> writes:
> am connecting three tables in query. one table have 73000 records
> another two tables have 138000 records.
> but its take 12 sec for show 12402 rows in tables

Increasing work_mem would make those sort steps faster ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Torsten Förtsch
Date:
Subject: Re: slow query
Next
From: Luis Antonio Dias de Sá Junior
Date:
Subject: Re: Survey: Max TPS you've ever seen