elein wrote:
Hi Elein,
> autovacuum does special stuff when there is an approaching transaction
> wrap around.
> We have a lot of transactions and wrap around as much as once a week.
>
> We'd like to invoke vacuum to do the special stuff explicitly so that we
> can do it during lower traffic t
Please copy el...@varlena.com on responses. I am way behind on my
general mail.
autovacuum does special stuff when there is an approaching transaction
wrap around.
We have a lot of transactions and wrap around as much as once a week.
We'd like to invoke vacuum to do the special stuff exp
If you need to run some database really fast, try to put only all your
indexes onto ram disk. Look here... http://www.linux.com/feature/142658
They use SSD to store indexes (not data) for postgresql. A think the
same conclusions should apply for ram disk too.
And in wrost case (power off for
Paul Wehr writes:
> A last try on this question. In the absence of any response, I'll assume
> the postgresql query optimizer simply doesn't take foreign keys into
> account in this way.
It does not, and never has, and yes there's a TODO item about that.
regards, tom lan
On Mon, Apr 13, 2009 at 2:36 PM, Paul Wehr
wrote:
>
> I am looking for a way to get the plan to show only a seq scan of test2,
> since test1 does not contribute any columns, and we know from the
> not-deferrable-not-null-primary-key that there will always be exactly one
> match.
>
> Am I just miss
On Mon, 2009-04-13 at 14:44 -0700, Christophe wrote:
> On Apr 13, 2009, at 1:59 PM, Ivan Sergio Borgonovo wrote:
> > wget says it is a 1Gb file.
> > Is there anything smaller?
>
> Since I have the master right here, I'll be happy to reencode it to a
> smaller size (250mb is probably the reasonab
On Apr 13, 2009, at 2:54 PM, Joshua D. Drake wrote:
Yes Vimeo can download and I will have it up soon.
Thank you! My work here is done. :)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-gene
On Mon, 2009-04-13 at 23:48 +0200, Ivan Sergio Borgonovo wrote:
> was just thinking about a public "official" place for everybody.
> I'm going to sleep so I'm not going to miss the bandwidth required
> for downloading the full stuff ;) but still then it will have to
> find it's way back to a public
On Apr 13, 2009, at 1:59 PM, Ivan Sergio Borgonovo wrote:
wget says it is a 1Gb file.
Is there anything smaller?
Since I have the master right here, I'll be happy to reencode it to a
smaller size (250mb is probably the reasonable lower limit before the
video quality reaches the point that
On Mon, 13 Apr 2009 14:36:49 -0700
Steve Crawford wrote:
> Scott Marlowe wrote:
> >>> http://media.postgresql.org/sfpug/sfpug-cloud-20090408.mov
> >>> Thanks to Josh Berkus for his organizational talents, and Dirk
> >>> Jagdmann for running the live streaming during the event.
> >> wget sa
Scott Marlowe wrote:
...
http://media.postgresql.org/sfpug/sfpug-cloud-20090408.mov
Thanks to Josh Berkus for his organizational talents, and Dirk
Jagdmann for running the live streaming during the event.
wget says it is a 1Gb file.
Is there anything smaller?
If you'd like
On Mon, Apr 13, 2009 at 2:59 PM, Ivan Sergio Borgonovo
wrote:
> On Mon, 13 Apr 2009 13:11:23 -0700
> Christophe wrote:
>
>> http://media.postgresql.org/sfpug/sfpug-cloud-20090408.mov
>>
>> Thanks to Josh Berkus for his organizational talents, and Dirk
>> Jagdmann for running the live streamin
On Mon, Apr 13, 2009 at 1:36 PM, Paul Wehr
wrote:
>
> A last try on this question. In the absence of any response, I'll assume
> the postgresql query optimizer simply doesn't take foreign keys into
> account in this way.
>
> Original Message
> Subject: Using foreign key constrai
On Mon, 13 Apr 2009 13:11:23 -0700
Christophe wrote:
> http://media.postgresql.org/sfpug/sfpug-cloud-20090408.mov
>
> Thanks to Josh Berkus for his organizational talents, and Dirk
> Jagdmann for running the live streaming during the event.
wget says it is a 1Gb file.
Is there anything sm
A last try on this question. In the absence of any response, I'll assume
the postgresql query optimizer simply doesn't take foreign keys into
account in this way.
Original Message
Subject: Using foreign key constraint to eliminate unnecessary joins in
view
Date: Sun, 29 Mar 200
On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones wrote:
> When I try to run
> % psql
> as the postgres user, I get the error
> psql: FATAL: no pg_hba.conf entry for host "[local]", user "postgres",
> database "postgres", SSL off
>
> I don't understand this error, since the pg_hba.conf file includes th
On Mon, 2009-04-13 at 17:36 -0300, Emanuel Calvo Franco wrote:
> >Thanks for your reply,but what I am actually looking for is
> > database should be an in-memory database and at the same i want to store
> > that data into disk so that data won't be lost when the system restarts or
>
On Mon, Apr 13, 2009 at 2:06 PM, aravind chandu wrote:
>
>
> Hello,
>
> Thanks for your reply,but what I am actually looking for is
> database should be an in-memory database and at the same i want to store
> that data into disk so that data won't be lost when the system restarts or
2009/4/13 aravind chandu :
>
>
> Hello,
>
> Thanks for your reply,but what I am actually looking for is
> database should be an in-memory database and at the same i want to store
> that data into disk so that data won't be lost when the system restarts or
> in case of power failure.
Greetings,
The video from the April 8, 2009 SFPUG meeting, "PostgreSQL in the
Cloud," is now available for viewing or download from the
media.postgresql.org server:
http://media.postgresql.org/sfpug/sfpug-cloud-20090408.mov
Thanks to Josh Berkus for his organizational talents, and Dirk
Hello,
Thanks for your reply,but what I am actually looking for is
database should be an in-memory database and at the same i want to store that
data into disk so that data won't be lost when the system restarts or in case
of power failure. Can you guys tell me the procedure
When I try to run
% psql
as the postgres user, I get the error
psql: FATAL: no pg_hba.conf entry for host "[local]", user "postgres",
database "postgres", SSL off
I don't understand this error, since the pg_hba.conf file includes the line:
local all all ident sameuser
What could explain this
On Mon, Apr 13, 2009 at 2:40 PM, Tino Wildenhain wrote:
> justin wrote:
>>
>>
>> Tom Lane wrote:
>>>
>>> Tino Wildenhain writes:
>>>
I would not recommend to do this within the database. Thats typical
a job for your presentation layer.
>>>
>>> ... but having said that, I think
Tino Wildenhain wrote:
justin wrote:
I disagree the database is the wrong place, there are cases it makes
sense.
Which cases would that be?
Regards
Tino
Report engines that don't have this ability . I use for check writing.
To come think, I don't know of UI framework or report engine
justin wrote:
Tom Lane wrote:
Tino Wildenhain writes:
I would not recommend to do this within the database. Thats typical
a job for your presentation layer.
... but having said that, I think the "money" datatype has a function
for this. Whether that's of any use to you I dunno; mo
2009/4/12 John R Pierce :
> aravind chandu wrote:
>>
>> I created in-memory database but the problem is all the data
>> will be accessed from main memory .when ever the system is restarted the
>> entire data that is in the tables will lost.Is there any way to dump all the
>> data in to l
Radcon Entec wrote:
> I was connected remotely
[snip]
> Can anybody explain this?
It's much more likely to be an issue with your remote software. At a
guess, you were using RDP ("Remote Desktop") to control the remote host?
It tries to be clever with the way it sends data, but it *can* get
con
On 13/04/2009 17:04, Raymond O'Donnell wrote:
> [Redirecting to the list]
>
Wrong list - sorry.
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
r...@iol.ie
Galway Cathedral Recitals: http://www.galwaycathed
[Redirecting to the list]
On 13/04/2009 16:33, gaybana2...@hotmail.com wrote:
> Thank you for your reply. I only have pgadmin3 installed. where do I
> run these commands from. what do I need to install to rund these
> command line commands?
What platform are you on? Also, what exactly are you try
On Sun, Apr 12, 2009 at 5:52 AM, Simon Riggs wrote:
> The database is performing too frequent restartpoints.
>
> This has been optimised in PostgreSQL 8.4 by the addition of the
> bgwriter running during recovery. This will mean that your hot spare
> will not pause while waiting for restartpoint t
On 13/04/2009 13:49, sandiphw wrote:
> invalid entry in the file pg_hba.conf at line 82, token "ldap://202..
> "
> fatal: missing of erroneous pg_hba.conf file
Have you got double-quotes around the entry in ph_hba.conf? According to
the docs, it's a good idea to do that.
http://www.postg
Sorry, forget to mention the log message of pgsql:
invalid entry in the file pg_hba.conf at line 82, token "ldap://202..
"
fatal: missing of erroneous pg_hba.conf file
--
View this message in context:
http://www.nabble.com/pgSql-authentication-problem-with-openLdap-tp23021809p23021943.h
Greetings!
I just ran across one of the strangest pieces I have ever seen in a piece of
software.
I was connected remotely to a test machine set up at a customer's site. The
machine is running Windows XP and PostgreSQL 8.1. PGAdmin has a connection to
the customer's production database, whic
We have installed postgresql 8.1.11 in CentOS, also installed openLdap
2.3.27. I have tried a lot to authenticate the user against ldap but
couldn't succeed. Can anyone pl help me out?
I have added the following entry in pg_hba.conf
host all all 202.18.10.0/24
ldap://202.18.10.1:389/dc=abc,
Hi,
The following cmd can be used for installating postgres as a service:
pg_ctl.exe register -N -U -P -D
and "pgctl.exe unregister -N " can be used to uninstall.
Thanks.
On Mon, Apr 13, 2009 at 12:15 PM, Craig Ringer
wrote:
> CM J wrote:
> > Hi ,
> >
> >I have extracte
CM J wrote on 13.04.2009 07:48:
Hi ,
I have extracted postgres from postgres-noinstaller.zip file. How
do i install postgres as a service from cmd line ? Are there are any
binaries provided by postgres to install it as a service ? Please note
that i am aware that msi installer automat
Craig Ringer wrote:
CM J wrote:
Hi ,
I have extracted postgres from postgres-noinstaller.zip file. How do
i install postgres as a service from cmd line ?
Search: http://msdn.microsoft.com/
You can use the `net' command to start/stop services. I don't recall the
command(s) us
37 matches
Mail list logo
