Re: [GENERAL] General performance/load issue

2011-11-27 Thread Gaëtan Allart
Actually, this is because I changed sort_mem to 4 Mb as asked by Robert. I removed this setting.. Gaëtan Le 26/11/11 18:58, « Tomas Vondra » t...@fuzzy.cz a écrit : Dne 26.11.2011 18:08, Gaëtan Allart napsal(a): UhmŠ I'm seeing dozens and dozens of temporary file creations in logs :

Re: [GENERAL] CPU move

2011-11-27 Thread Frank Lanitz
Am 26.11.2011 19:18, schrieb Carlos Henrique Reimer: Hi, We're planning to move our postgreSQL database from one CPU box to another box. I'm considering an alternative procedure for the move as the standard one (pg_dump from the old, copy dump to the new box, psql to restore in the new)

Re: [GENERAL] CPU move

2011-11-27 Thread frank
This message has been digitally signed by the sender. Re___GENERAL__CPU_move.eml Description: Binary data - Hi-Tech Gears Ltd, Gurgaon, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] General performance/load issue

2011-11-27 Thread Tomas Vondra
On 27 Listopad 2011, 10:45, Gaëtan Allart wrote: Actually, this is because I changed sort_mem to 4 Mb as asked by Robert. I removed this setting.. This is exactly the reason why it's recommended not to do any changes until it's reasonably certain what is the caause. Did increasing the

Re: [GENERAL] text search synonym dictionary anomaly with numbers

2011-11-27 Thread Oleg Bartunov
Richard, you should check your mapping - '1st' belongs to 'numword' and may be processed in a different way than 'first' or '1'. Oleg On Sat, 26 Nov 2011, Richard Greenwood wrote: I am working with street address data in which 'first st' has been entered as '1 st' and so on. So I have created

Re: [GENERAL] text search synonym dictionary anomaly with numbers

2011-11-27 Thread Richard Greenwood
Oleg, Thank you. I am sure that you have identified my problem. \dF+ english (output below) lists my dictionary which is named 'rwg_synonym' before numword so I would have thought that my dictionary would have normalized '1st' to '1' before the numword dictionary was reached. Maybe this

[GENERAL] PostgreSQL poster

2011-11-27 Thread Ivan Voras
I was looking for some PostgreSQL promotional material and found this: http://imgur.com/4VUUw I would very much like to get a high-res version of this image - does anyone here have it? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] text search synonym dictionary anomaly with numbers

2011-11-27 Thread Richard Greenwood
To answer my own question - my synonym dictionary was not be applied to '1st' because '1st' is a numword, not an asciiword, and my synonym dictionary was not mapped to numword. To map a dictionary token class: ALTER TEXT SEARCH CONFIGURATION english ALTER MAPPING FOR numword WITH

[GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Mike Christensen
I have a table with this layout: CREATE TABLE Favorites ( FavoriteId uuid NOT NULL, --Primary key UserId uuid NOT NULL, RecipeId uuid NOT NULL, MenuId uuid ) I want to create a unique constraint similar to this: ALTER TABLE Favorites ADD CONSTRAINT

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Pavel Stehule
Hello 2011/11/27 Mike Christensen m...@kitchenpc.com: I have a table with this layout:    CREATE TABLE Favorites    (      FavoriteId uuid NOT NULL, --Primary key      UserId uuid NOT NULL,      RecipeId uuid NOT NULL,      MenuId uuid    ) I want to create a unique constraint similar

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Thomas Kellerer
Mike Christensen wrote on 27.11.2011 22:18: I have a table with this layout: CREATE TABLE Favorites ( FavoriteId uuid NOT NULL, --Primary key UserId uuid NOT NULL, RecipeId uuid NOT NULL, MenuId uuid ) I want to create a unique constraint similar to

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Mike Christensen
On Sun, Nov 27, 2011 at 1:47 PM, Thomas Kellerer spam_ea...@gmx.net wrote: Mike Christensen wrote on 27.11.2011 22:18: I have a table with this layout:     CREATE TABLE Favorites     (       FavoriteId uuid NOT NULL, --Primary key       UserId uuid NOT NULL,       RecipeId uuid NOT NULL,

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread David Johnston
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Mike Christensen Sent: Sunday, November 27, 2011 5:02 PM To: Thomas Kellerer Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Way to create unique constraint in

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Mike Christensen
On Sun, Nov 27, 2011 at 2:18 PM, David Johnston pol...@yahoo.com wrote: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Mike Christensen Sent: Sunday, November 27, 2011 5:02 PM To: Thomas Kellerer Cc:

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread Thomas Kellerer
David Johnston wrote on 27.11.2011 23:18: Also, the index example above presumes you want RecipeId to be Null-able as opposed to MenuId as described in your original post. Well of course that was a typo in my answer, it should have been: CREATE UNIQUE INDEX Favorites_UniqueFavorite ON

Re: [GENERAL] Way to create unique constraint in Postgres even with null columns

2011-11-27 Thread David Johnston
On Nov 27, 2011, at 17:43, Mike Christensen m...@kitchenpc.com wrote: On Sun, Nov 27, 2011 at 2:18 PM, David Johnston pol...@yahoo.com wrote: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Mike Christensen Sent:

[GENERAL] reading build config.log -- possible bug?

2011-11-27 Thread Rob Sargentg
Looking to see where my new data directory is in recently built 9.1 I happened upon what could potentially be a bug in configure: Just after the line which begins configure_args= (line 11068 for me, 99% of buffer) I find: datadir='${datarootdir}' datarootdir='${prefix}/share' I'm troubled

Re: [GENERAL] reading build config.log -- possible bug?

2011-11-27 Thread Tom Lane
Rob Sargentg robjsarg...@gmail.com writes: Looking to see where my new data directory is in recently built 9.1 I happened upon what could potentially be a bug in configure: Just after the line which begins configure_args= (line 11068 for me, 99% of buffer) I find: datadir='${datarootdir}'

Re: [GENERAL] reading build config.log -- possible bug?

2011-11-27 Thread Rob Sargentg
On 11/27/2011 09:31 PM, Tom Lane wrote: Rob Sargentgrobjsarg...@gmail.com writes: Looking to see where my new data directory is in recently built 9.1 I happened upon what could potentially be a bug in configure: Just after the line which begins configure_args= (line 11068 for me, 99% of