[GENERAL] Question about database configuration

2011-02-08 Thread Niklas Langvig
Hello We have a database running on Windows Server 2008 standard 32bit using Postgres 8.3 If I run a specific query on this database it takes about 4 seconds If I do explain analyze on the query it takes about 17 seconds and I get this result in the beginning Unique (cost=43820.39..43822.51 row

[GENERAL] PostgresSQL 9.0 64 bit on windows 2008 64bit

2011-02-15 Thread Niklas Langvig
Hi We currently use postgres 8.3 on windows 2008 32bit With max_connections set to 1000 Since we have more than 125 connections, we run postgres as a stand alone process instead of as a service. http://wiki.postgresql.org/wiki/Running_&_Installing_PostgreSQL_On_Native_Windows#I_cannot_run_with_mor

[GENERAL] syntax error collate

2012-10-03 Thread Niklas Langvig
Hello If I do this from pgAdmin on windows to my localhost database 9.2 it works fine CREATE COLLATION Test ( LOCALE = 'en_US.UTF-8' ) If I connect to a linux server and do the sameI get ERROR: syntax error at or near "COLLATION" LINE 1: CREATE COLLATION Test ( On linux we have version strin