For exaple this http://www.postgresql.org/files/documentation/pdf/9.0/postgresql-9.0-US.pdf 20.12.2010, 04:05, "Wang, Mary Y" :Hi All, I'd like to read more case studies on PostGIS. I know some case studies are listed in http://postgis.refractions.net/ . Are there more case studies that you
I recreated the 2 "bad" DBs (the ones with millions of files in them). So far,
they're behaving.
Thanks for the help.
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Saturday, December 18, 2010 1:29 PM
To: Gauthier, Dave
Cc: Bill Moran; pgsql-general@postgresq
Hi All,
I'd like to read more case studies on PostGIS. I know some case studies are
listed in http://postgis.refractions.net/ .
Are there more case studies that you can refer me to?
Thanks in advance.
Mary
Hi,
I'm about to upgrade a 700GB 8.4 db to version 9.0.2, and I'm curious if
there is any benefit to switching from my current lc_collate setting of
"en_US.UTF-8" to C. I read over the docs a couple times, but couldn't really
find anything conclusive other than the statement that settings other th
2010/12/19 Oleg Bartunov :
> You might be interested in http://www.sai.msu.su/~megera/wiki/2009-08-12
Thanks, that looks pretty much like what I had in mind. Hopefully
that'll get merged for 9.0+1; phrases are a major part of all text
searches.
--
Glenn Maynard
--
Sent via pgsql-general maili
On 19dic, 2010, at 10:33 , Jasen Betts wrote:
> On 2010-12-17, Raimon Fernandez wrote:
>> Hi,
>>
>> I'm trying to solve what I think must be a real trivial question.
>>
>> When I use psql after every DELETE FROM table WHERE id= I get how many
>> rows were affected, in this case, deleted.
On Dec 17, 2010, at 4:22 PM, Gauthier, Dave wrote:
> max_fsm_pages = 20
Don't know that this is related, but that count is pretty low. If you run a
vacuumdb -av and capture the output, the very end will tell you how many FSM
pages you actually need; it's very possible 200,000 isn't enough.
-
On Dec 17, 2010, at 10:34 AM, Melvin Davidson wrote:
> >please don't name your constraint using the same name you named your
> >table.
>
> I can't believe I missed the obvious, but that's why it's better to have
> someone else
> take a look.
> Thanks for spotting that. I've tacked on _pk to the
version: 8.3
The other day, my DB stop processing request. It still accepts connections
but not processing those.
So I quit all client connections from client yet those process still alive
on SQL Server.
I tried to Stop DB by issuing pt_ctl STOP -m fast but failed to shut down
database.
Next I issu
No. I'm Administrator.
About TEMP:
- %USERPROFILE%\AppData\Local\Temp (this is for current user)
- %SystemRoot%\TEMP (system var)
Im elso check disk free space - it's ok.
- Original Message -
From: "Raymond O'Donnell"
To: "tbazadaykin"
Cc:
Sent: Sunday, December 19, 2010 8:04 PM
S
On 19/12/2010 16:53, tbazadaykin wrote:
Hi. When installing PostrgeSQL (no mater 32 or 64-bit) on Windows
Vista Home Premium (64-bit) i a get error message "Unable to write
inside TEMP environment variable path." Any idea?
Permissions maybe?
What is TEMP set to?
Ray.
--
Raymond O'Donnell ::
Hi.
When installing PostrgeSQL (no mater 32 or 64-bit) on Windows Vista Home
Premium (64-bit) i a get error message "Unable to write inside TEMP environment
variable path." Any idea?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
You might be interested in http://www.sai.msu.su/~megera/wiki/2009-08-12
Oleg
On Sun, 19 Dec 2010, Glenn Maynard wrote:
I guess no response means it's not possible. I ended up doing a
manual substring match for quoted strings, but that's a poor hack.
Maybe I'll take a poke at implementing some
On 2010-12-08, Tom Lane wrote:
> Adrian Klaver writes:
>> On 12/08/2010 08:04 AM, Tom Lane wrote:
>>> The rationale for having a limit of this sort is (a) we *don't* want
>>> the upper limit of declarable length to be encoding-dependent; and
>>> (b) if you are trying to declare an upper limit tha
On 2010-12-16, pgsql.30.miller_2...@spamgourmet.com
wrote:
> --0015174c1e4aaf077604977d7e62
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi -
>
> Issue:
> How to return a sequence value generated upon INSERT of records into a
> partitioned table using trigger functions (without having t
On 2010-12-17, Raimon Fernandez wrote:
> Hi,
>
> I'm trying to solve what I think must be a real trivial question.
>
> When I use psql after every DELETE FROM table WHERE id= I get how many
> rows were affected, in this case, deleted.
>
> Also I've implemented the full FrontEnd/BackEnd Protoc
I guess no response means it's not possible. I ended up doing a
manual substring match for quoted strings, but that's a poor hack.
Maybe I'll take a poke at implementing something like
tsvector_contains_phrase; it seems like a natural extension of what's
in there now.
On Mon, Nov 1, 2010 at 4:35
17 matches
Mail list logo
