On Fri, Jul 28, 2006 at 10:09:00PM -0400, Alvaro Herrera wrote:
> Flemming Frandsen wrote:
> > The strange thing is that just about any query runs in 1-4ms, but the
> > listen command, which shouldn't even have to touch the disk takes around
> > 60ms.
>
> Actually, it does write to disk, because
Flemming Frandsen wrote:
> I cache a lot of data in the application, to invalidate that cache I
> have triggers that use notify to let new transactions eject the objects
> from the cache.
>
> My problem with listen is that when I start a new connection I run a
> listen command for each of my ta
[My ISP has had a power failure and my outgoing mail appears to bouncing, but I'm unsure -- apologies if you receive multiple copies.]
On Wed, 2006-07-26 at 13:38 -0700, Reece Hart wrote:
If you can release the data and get it to me (e.g., compressed email attachment, http, ftp), I volunt
Note that starting in 8.0/8.1, you can sometimes get very large gains
by setting shared_buffers very high; 1/2 of memory or more.
On Jul 27, 2006, at 4:00 PM, Shoaib Mir wrote:
Go to http://www.powerpostgresql.com/PerfList/ and see the
shared_buffers settings section there.
Thanks,
--
Shoa
On Jul 28, 2006, at 5:47 PM, gene Campbell wrote:
I have poked around a bit, and am finally resorting to taking up
some cycles in this list.
Please forgive me.
I have a pg_hba.conf file that is setup like this
hostdb1 user1 222.152.155.194/32md5
From time to time, my ISP
Hello,
I have poked around a bit, and am finally resorting to taking up some
cycles in this list.
Please forgive me.
I have a pg_hba.conf file that is setup like this
hostdb1 user1 222.152.155.194/32md5
From time to time, my ISP changes my ip address on me.
At that point,
I cache a lot of data in the application, to invalidate that cache I
have triggers that use notify to let new transactions eject the objects
from the cache.
My problem with listen is that when I start a new connection I run a
listen command for each of my tables, that loop takes around 10 seco
"Alistair Bayley" <[EMAIL PROTECTED]> writes:
> Actually, looking at the code again, I can see what happens, I think.
> This entry in win32_tzmap maps my GMT timezone to PG's Europe/Dublin
> timezone:
> {
> "GMT Standard Time", "GMT Daylight Time",
> "Europe/Dublin
On 28/07/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Alistair Bayley" <[EMAIL PROTECTED]> writes:
> I was puzzled as to why it is set to Dublin when my machine's Time
> Zone is GMT. I saw in the docs that in the absense of an entry in the
> .conf file or a TZ environment variable results in a guess
On Fri, Jul 28, 2006 at 12:00:19PM +0200, DANTE Alexandra wrote:
> Hello List,
>
> I try to understand perfectly the mecanisms used to update / delete a
> tuple (and consequently those used in VACUUM) and I've got some questions.
> I hope someone could answer these questions :
> - what are the
On 7/28/06, Arnaud Lesauvage <[EMAIL PROTECTED]> wrote:
Csaba Nagy wrote:
> I found that PITR using WAL shipping is not protecting against all
> failure scenarios... it sure will help if the primary machine's hardware
> fails, but in one case it was useless for us: the primary had a linux
> kerne
Richard Huxton wrote:
gustavo halperin wrote:
On 7/28/06, Shoaib Mir <[EMAIL PROTECTED]> wrote:
You can use loops (
http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html).
Thanks
Are you trying to do some performance analysis for the database server?
Yes
Michael Fuhr a écrit :
Arnaud has probably already realized that postgis-users would be a
better place to ask this. Here's the same thread on that list:
http://postgis.refractions.net/pipermail/postgis-users/2006-July/012790.html
Yes sorry for that, I receive everything in the same folder an
Please follow the story and help !!!
The postgresql source doesnt have any version for windows ?? Iam I right or wrong ??
I have downloaded the binary zip for windows.
The binary zip has only the release DLL s it does not have the DEBUG dlls ...
I have also downloaded libpqxx ... since i
Jessica M Salmon <[EMAIL PROTECTED]> writes:
> -is it true that when looping over query results in a plpgsql
> for..in..execute loop, several records are stored in memory at one time?
Yes, but that's got nothing to do with your issue.
> -if I then update one of the records currently i
On Fri, Jul 28, 2006 at 11:44:17AM +0200, Arnaud Lesauvage wrote:
> I received a bunch of shapefiles with a .prj file.
> I can't find the projection in the spatial_ref_sys table (it looks
> quite strange, it says "IGNBelg_Lam72").
> How can I insert a record for this projection in the
> spatial_r
"David Esposito" <[EMAIL PROTECTED]> writes:
>> -Original Message-
>> From: Tom Lane [mailto:[EMAIL PROTECTED]
>> The default selinux policy prevents postgres from writing anywhere
>> except under /var/lib/pgsql. If you want a nondefault PGDATA location
>> then you have to tweak the polic
I'm not sure if my second email made it through; I haven't seen it on the
website yet. But, basically, what I am asking is this:
-is it true that when looping over query results in a plpgsql
for..in..execute loop, several records are stored in memory at one time?
and if so, then I am wonderin
Hi list !
I received a bunch of shapefiles with a .prj file.
I can't find the projection in the spatial_ref_sys table (it looks
quite strange, it says "IGNBelg_Lam72").
How can I insert a record for this projection in the
spatial_ref_sys table ?
Here is the .prj file content :
PROJCS["IGNBelg
> Most things in the world don't work that way: you can't take two
> customers and make a third. I'm sure there's a mathematical way to
> express this better...
I'm pretty sure there are other newsgroups where one can go to find examples
of putting two people together to try and make a third one ;
"Alistair Bayley" <[EMAIL PROTECTED]> writes:
> I was puzzled as to why it is set to Dublin when my machine's Time
> Zone is GMT. I saw in the docs that in the absense of an entry in the
> .conf file or a TZ environment variable results in a guess; this seems
> to be the cause here. I see in
> htt
On 26/07/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Alistair Bayley" <[EMAIL PROTECTED]> writes:
> The first line of output puzzles me: why is '1916-10-01 02:25:20'
> 2627158159 seconds before 2000-01-01, while '1916-10-01 02:25:21' is
> 2627156080 before; a difference of 2080 seconds, or 34m:40s.
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
>
> The default selinux policy prevents postgres from writing anywhere
> except under /var/lib/pgsql. If you want a nondefault PGDATA location
> then you have to tweak the policy.
>
It's not that simple ... if I su to post
Hello List,
I try to understand perfectly the mecanisms used to update / delete a
tuple (and consequently those used in VACUUM) and I've got some questions.
I've created a small database with only one table called "nation". This
table was created with this command :
CREATE TABLE nation(
gustavo halperin wrote:
On 7/28/06, Shoaib Mir <[EMAIL PROTECTED]> wrote:
You can use loops (
http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html).
Thanks
Are you trying to do some performance analysis for the database server?
Yes I will, but first I want see
Merlin Moncure wrote:
I am currently deploying two servers (Windows 2003 R2) that will
be used as file servers as well as PostgreSQL servers.
One of the server will be the main server, the other one a backup
server (no load-balancing, only an easy-recoverage solution).
The goal is to be able to
Csaba Nagy wrote:
for a cold/warm standby postgresql backup, I'd suggest using pitr.
I found that PITR using WAL shipping is not protecting against all
failure scenarios... it sure will help if the primary machine's hardware
fails, but in one case it was useless for us: the primary had a linux
For doing the performance analysis you can use BenchmarkSQL (http://sourceforge.net/projects/benchmarksql) and while you do the benchmarking make sure you have your PostgreSQL database server properly tuned following the instructions given at
http://www.powerpostgresql.com/PerfList/Hope this helps
28 matches
Mail list logo
