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 :
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)
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:
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
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
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
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
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
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
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
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
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,
-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
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:
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
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:
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
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}'
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
19 matches
Mail list logo