Postgres Pro
Downloads
Home   >   mailing lists

Re: Asking advice on speeding up a big table - Mailing list pgsql-general

From Tom Lane
Subject Re: Asking advice on speeding up a big table
Date
Msg-id 17315.1144651890@sss.pgh.pa.us
Whole thread Raw
In response to Asking advice on speeding up a big table  (felix@crowfix.com)
Responses Re: Asking advice on speeding up a big table  (felix@crowfix.com)
List pgsql-general
Tree view 
felix@crowfix.com writes:
> I have a simple benchmark which runs too slow on a 100M row table, and
> I am not sure what my next step is to make it faster.

The EXPLAIN ANALYZE you showed ran in 32 msec, which ought to be fast
enough for anyone on that size table.  You need to show us data on the
problem case ...

            regards, tom lane

pgsql-general by date:

Previous
From: felix@crowfix.com
Date:
Subject: Asking advice on speeding up a big table
Next
From: "surabhi.ahuja"
Date:
Subject: Re: postmaster going down own its on