Re: [GENERAL] How to find which query a waiting query waiting for?

I know how to do this, thanks. On Fri, Dec 7, 2012 at 11:09 PM, Fabrízio de Royes Mello < fabriziome...@gmail.com> wrote: > > On Fri, Dec 7, 2012 at 1:02 PM, wd wrote: > >> hi, >> >> From pg_stat_activity I can find a query is at waiting state, and from >> pg_locks and pg_class can find which r

[GENERAL] Query and index ... unexpected result need advice.

Hello, Yesterday when I read the email I came across an issue and I thought very interesting result. The topic is: "Table with million rows - and PostgreSQL 9.1 is not using the index". I decided to try it because from 250 ms with millions rows to 15 ms is very good, but I did not get the expe

Re: [GENERAL] Large temporary file generated during query

On Fri, Dec 12/07/12, 2012 at 05:33:45PM -0800, Jeff Janes wrote: > On Fri, Dec 7, 2012 at 1:58 PM, Ryan Kelly wrote: > > I have a very large query that also touches quite a bit of data. It > > generates a large temporary file (actually, several, because the total > > size is about 4.5GB). I'm won