Hi. We have a server provided for a test of a web application with the
following specifications:
1 Dual core 1.8GHz Opteron chip
6 GB RAM
approx 250GB of RAID10 storage (LSI card + BBU, 4 x 15000 RPM,16MB
Cache SCSI disks)
The database itself is very unlikely to use up more than 5
On Sat, 3 Dec 2005 23:00:21 +, Rodrigo Madera <[EMAIL PROTECTED]> wrote:
> Imagine a table named Person with "first_name" and "age".
>
> Now let's make it fancy and put a "mother" and "father" field that is
> a reference to the own table (Person). And to get even fuzzier, let's
> drop in some
"Markus Wollny" <[EMAIL PROTECTED]> writes:
>> Once you're not under deadline,
>> I'd like to investigate more closely to find out why 8.1 does
>> worse than 8.0 here.
> Does this tell you anything useful? It's not on the same machine, mind
> you, but configuration for PostgreSQL is absolutely ide
Title: RE: [PERFORM] Queries taking ages in PG 8.1, have been much faster in PG<=8.0
Hi!
> -Ursprüngliche Nachricht-
> Von: Tom Lane [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 1. Dezember 2005 17:26
> An: Markus Wollny
> Cc: pgsql-performance@postgresql.org
> Betreff: Re: [P
Hélder M. Vieira wrote:
- Original Message - From: "Andreas Pflug"
<[EMAIL PROTECTED]>
Create a table "sibling" with parent_id, sibling_id and appropriate
FKs, allowing the model to reflect the relation. At the same time, you
can drop "mother" and "father", because this relation is
William Yu schrieb:
> Michael Riess wrote:
>>> Well, I'd think that's were your problem is. Not only you have a
>>> (relatively speaking) small server -- you also share it with other
>>> very-memory-hungry services! That's not a situation I'd like to be in.
>>> Try putting Apache and Tomcat else
Michael Riess wrote:
Well, I'd think that's were your problem is. Not only you have a
(relatively speaking) small server -- you also share it with other
very-memory-hungry services! That's not a situation I'd like to be in.
Try putting Apache and Tomcat elsewhere, and leave the bulk of the 1GB
