On Thu, Dec 2, 2010 at 2:04 PM, Piotr Czekalski wrote:
> Hello Postgres Users.
>
> Last days I've installed and configured new x64 release of PostgreSQL
> running Windows 2008 R2 with dual XEON 5530 processors (2x4xHT = 16 working
> units). Previously the database was running on Fedora 12 x86_64 u
Hello Postgres Users.
Last days I've installed and configured new x64 release of PostgreSQL
running Windows 2008 R2 with dual XEON 5530 processors (2x4xHT = 16
working units). Previously the database was running on Fedora 12 x86_64
under Microsoft hypervisor (HyperV) thus because of the networ
Mario Splivalo wrote:
> It is OT, but, could you please shead just some light on that?
> Part of my next project is to test performance of pg9 on both
> windows and linux systems so I'd appreciate any data/info you both
> may have.
I don't know how much was the filesystem, but with both tuned
On 12/01/2010 10:43 PM, Pierre C wrote:
On Wed, 01 Dec 2010 18:24:35 +0100, Kevin Grittner
wrote:
Mladen Gogala wrote:
There is a operating system which comes with a very decent extent
based file system and a defragmentation tool, included in the OS.
The file system is called "NTFS"
Been t
On 12/01/2010 09:43 AM, Pierre C wrote:
Note that in both cases postgres reports that the FK checks take 92-120
milliseconds... which is a normal time for about 4000 rows.
Inserting 4000 lines with just a few fields like you got should take
quite much less than 1 s...
Where the rest of the time
