Re: Asking advice on speeding up a big table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: felix-accts-pgsql(at)crowfix(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Asking advice on speeding up a big table
Date: 2006-04-10 06:51:30
Message-ID: 17315.1144651890@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

felix(at)crowfix(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message surabhi.ahuja 2006-04-10 07:09:43 Re: postmaster going down own its on
Previous Message felix 2006-04-10 06:17:36 Asking advice on speeding up a big table