Is there a good place that summarizes the OS tools I should
be using to monitor postgresql servers on various machines?
On *nix machines I have sar/sysstat stuff constantly logging
stuff; but on Win* machines I don't know what the equivalent
should be. Any recommendations?
For interactive monit
temporary space) so
/base/[whatevernumber]/pgsql_tmp
should be a symlink to something on the ramdisk as well.
(Kinda off-topic -- anecdotally it feels to me that some queries
go faster if I put /pgsql_tmp on a different device & disk controller.
If I verify this I'll post result
Lucio wrote:
Hi,
I'am trying to create a demo cd (knoppix) with a jdbc application.
This application uses a static (read-only, no insert, modify or delete) 200MB
postgresql db, so can't put pgsql/data/base and pgsql/data/pg_xlog in ramdisk.
One thing I don't think I saw mentioned yet
I think
Chuming Chen wrote:
I want to set up a web site using apache httpd, php and postgresql. From
the performance point of view, which architecture is better? 1) Run
httpd and postgresql on the same machine; 2) Run postgresql on seperate
machine. My concern is that the machine I am going to run htt
I may be implementing a database at a customer's site that would
ideally run administration free for a year or so -- or at least
be able to have scripts detect proactively if they'd need to call
us for support before the system starts behaving poorly.
Is there a way to parse the output of "vacuum"
Tom Lane wrote:
David B <[EMAIL PROTECTED]> writes:
15minute lock is a long time.
There's no lock, unless you are using VACUUM FULL which you shouldn't.
Or, I believe, if he has any GIST indexes (such as tsearch or
postgis ones). At least it seems normal vacuum locks GIST indexes
for quite some ti
Peter Eisentraut wrote:
Chris Hoover wrote:
Also, are there any other good companies to consider for support?
http://techdocs.postgresql.org/companies.php
Any reason Fujitsu (http://fastware.com.au/postgresql_support.html) isn't
on that list?
I think it adds quite a bit of credibility when I tell
Gergely CZUCZY wrote:
> On Thu, Feb 21, 2008 at 11:53:35AM -0500, Carol Walter wrote:
>> A colleague told me that the latest stable release of PostgreSQL is 8.1.x.
>> I thought it was 8.2.4. What is the latest stable release?
>> I thought there was a problem with autovacuum in the earlier rele
Tom Lane wrote:
On Tue, Feb 26, 2008 at 12:08 AM, Suresh Gupta VG <[EMAIL PROTECTED]> wrote:
May I know what is the stable pgsql release and latest?
This topic has been addressed very recently, see this thread:
http://archives.postgresql.org/pgsql-admin/2008-02/msg00238.php
Yeah - and from t
Naomi Walker wrote:
> Other than disaster tests, how would I know if I have an system that
> lies about fsync?
Well, the linux kernel tries to detect it on bootup and
will give messages like this:
%dmesg | grep 'disabling barriers'
JBD: barrier-based sync failed on md1 - disabling barriers
J
Kevin Grittner wrote:
> Chris Browne wrote:
>
>> I'd suggest adding an index
>
> The OP said the table had 15 indexes already. I would guess one of
> those could be used. Perhaps it has a primary key
>
>> update table1 set new_column = [whatever calculation]
>> where new_column is
Scott Marlowe wrote:
> On Tue, Sep 15, 2009 at 3:58 AM, std pik wrote:
>> Hello all..
>> I'm using PostgreSQL 8.3..
>> How can I get information about the hardware utilization:
>> - CPU usage.
>> - Disk space.
>> - Memory allocation.
>> thank you.
>
> Dude, there was a whole thr
On Mon, 6 Jan 2003, Jeff Boes wrote:
>
> [...] Suddenly [...] ANALYZE isn't working properly (it is recording
> pg_class.reltuples far lower than the actual row count).
I had the same problem recently...
http://archives.postgresql.org/pgsql-bugs/2002-08/msg00015.php
where "vacuum analyze" and "
On Mon, 20 Jan 2003, Tom Lane wrote:
>
> Bhuvan A <[EMAIL PROTECTED]> writes:
> >> Error:...deadlock detected...
> > ... You can overcome this by locking the table in share row
> > exclusive mode also...
>
> ...use shorter transactions (one per page, not one per several pages).
Hmm... with his qu
On Mon, 20 Jan 2003, Tom Lane wrote:
>
> If I understood correctly, he's tracking webpage hits; so the updates
> are going to correspond to the sequence in which visitors move to
> different webpages.
Ah... I was thinking he was counting banners served within a
single page (perhaps a banner on to
> Hi all, i work in a telco and i have huge ammount of data, (50 million)
> but i see a lack of performance at huge tables with postgres,
> are 50 million rows the "limit" of postgres ? (with a good performance)
I have worked on a datawarehouse (postgresql 7.3) with a
pretty standard star schema
16 matches
Mail list logo
