- "Richard Neill" escreveu:
> Matthew Wakeling wrote:
> >
> > We're about to purchase a new server to store some of our old
> databases,
> > and I was wondering if someone could advise me on a RAID card. We
> want
> > to make a 6-drive SATA RAID array out of 2TB drives, and it will be
> R
- "Scott Marlowe" escreveu:
> On Tue, Nov 24, 2009 at 1:37 PM, Ing. Marcos Ortiz Valmaseda
> wrote:
> > Do you expose that performance issued caused by RAID 5? Because this
> is one
> > of our solutions here on my country to save the data of our
> PostgreSQL
> > database. Which model do you
Hello
- "Lefteris" escreveu:
> Hi all,
>
> following the simple but interesting air-traffic benchmark published
> at:
> http://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/
Quite interesting test, if you have the time to download all
- "Lefteris" escreveu:
> > Did you ever try increasing shared_buffers to what was suggested
> (around
> > 4 GB) and see what happens (I didn't see it in your posts)?
>
> No I did not to that yet, mainly because I need the admin of the
> machine to change the shmmax of the kernel and also beca
- "Matthew Wakeling" escreveu:
> On Thu, 7 Jan 2010, Gurgel, Flavio wrote:
> Postgres does not change a query plan according to the shared_buffers
>
> setting. It does not anticipate one step contributing to another step
> in
> this way. It does however make use
- "Scott Marlowe" escreveu:
> You do know that indexes in postgresql are not "covering" right?
> I.e.
> after hitting the index, the db then has to hit the table to see if
> those rows are in fact visible. So there's no such thing in pgsql,
> at
> the moment, as an index only scan.
That w
