Re: [PERFORM] big distinct clause vs. group by

2011-04-24 Thread Uwe Bartels
On 23 April 2011 21:34, Robert Haas wrote: > On Apr 18, 2011, at 1:13 PM, Uwe Bartels wrote: > > Hi Robert, > > > > thanks for your answer. > > the aggregate function I was talking about is the function I need to use > for the non-group by columns like min() in my example. > > There are of cours

Re: [PERFORM] How to configure a read-only database server?

2011-04-24 Thread Tomas Vondra
Dne 24.4.2011 11:38, Stefan Keller napsal(a): > AFAIK it helps at least bulk loading my data every other time. Yes, but this thread was about setting the DB for read-only workload, so those settings were a bit strange. > So I'm confused and backup again: Given a single-disk virtual Linux > system

Re: [PERFORM] How to configure a read-only database server?

2011-04-24 Thread Stefan Keller
AFAIK it helps at least bulk loading my data every other time. So I'm confused and backup again: Given a single-disk virtual Linux system and a 'read-only' dataset, which is exposed to the internet and completely replaced from time to time, and expecting SELECT queries including joins, sorts, equa