Since we're on the vacuum kick these days, what's the best way to tell if my
autovacuum settings are working well? I'm sure I can query some info out of
the pg_stats tables, no?
Also, if using autovacuum, should I still do a vacuum full on a regular
basis?
--
Jeff Frost, Owner <[EMAIL
Michael Fahey <[EMAIL PROTECTED]> writes:
> My database cluster at 22 GB is outgrowing the 30 GB partition I set
> aside for it.
> I periodically dump the cluster to a development server, but when it is
> loaded onto the development server, the cluster takes up just 145MB.
> I'm using 7.4.7-6sa
My database cluster at 22 GB is outgrowing the 30 GB partition I set
aside for it.
I periodically dump the cluster to a development server, but when it is
loaded onto the development server, the cluster takes up just 145MB.
I use temporary tables fairly extensively in a key part of the applic
Hi,
I've got a problem, I'm hoping someone can help me with.
It appears that my hosting provider has "restored" my database as
part of a maintenance project. The problem is that the backup didn't
include my large objects.
I've got an older backup that has all the large objects, but I don'
On Tue, Aug 30, 2005 at 01:59:04PM -0400, Postgres Admin wrote:
> ERROR: set-valued function called in context that cannot accept a set
> CONTEXT: PL/pgSQL function "article_sample" line 10 at return next
You don't show what you did to get this error, but I'd guess you
called the function like t
On Tue, Aug 30, 2005 at 07:51:58PM -0400, Lane Van Ingen wrote:
> Can somebody tell me (on Windows 2003) where the 'application subdirectory
> in the user's profile' is? I want to set up a pgpass.conf file. Nothing has
> worked so far. I am on version 8.0.0.
>
> -- from the Pos
Lane, %APPDATA% is an environment variable in Windows systems that refers to
the Application Data Subdir. It can differ depending on install options, so
you can find out for yourself, by just opening a CMD shell and doing the
following:
echo %appdata%
or even:
cd %appdata%
On my XP system,
Can somebody tell me (on Windows 2003) where the 'application subdirectory
in the user's profile' is? I want to set up a pgpass.conf file. Nothing has
worked so far. I am on version 8.0.0.
-- from the PostgreSQL
Documentation -
The file
On Tue, Aug 30, 2005 at 04:20:03PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > So does that mean a hash index could (theoretically) improve the
> > performance of a hash join or hash aggregation?
>
> I don't think so --- the whole point of a hash is to do your matching
Hey,
i searched the documentation and on the net but what i couldn't find a
documentation how to install PostgreSQL 8.0.3 on SUSE Linux Enterprice
Server 9.2 properly. Could someone tell me where to find it?
What i did until now: The Administrator of the box did donwload a version
from :
http:/
On Tue, 2005-08-30 at 14:32, Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> > Personally, I think that when one creates a non-btree index, one should
> > get a warning saying that non-btree indexes are not necessarily
> > transactionally safe in the event of a crash.
>
> As of 8.1,
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> So does that mean a hash index could (theoretically) improve the
> performance of a hash join or hash aggregation?
I don't think so --- the whole point of a hash is to do your matching
in-memory, rather than jumping all over the disk for it ...
On Tue, Aug 30, 2005 at 03:32:26PM -0400, Tom Lane wrote:
> That leaves hash. I'm hoping someone will step up and do WAL logging
> for hash in the near future. Unlike rtree, I'm not expecting that we
> might get rid of hash indexes. Even if the performance problems never
> get fixed, we use hash
Just so that we can snip this thread, we've confirmed that free cursor
and free statement do not affect sqlca structure elements sqlcode and
sqlstate.
Michael Fuhr wrote:
On Tue, Aug 30, 2005 at 09:01:36AM -0500, Thomas F. O'Connell wrote:
On Aug 29, 2005, at 2:19 PM, andy rost wrote:
$d
Cédric Buschini wrote:
- I would to synchrinize these 2 DB, how could I do that easily ? Maybe
with 'WAL' but I cannot figure out how . :s
I'm running 2 DB on 2 different servers : machines and versions (7.4.1
and 8.0.3)
I've setup the example rep in Slony-I and done some simple testing.
Scott Marlowe <[EMAIL PROTECTED]> writes:
> Personally, I think that when one creates a non-btree index, one should
> get a warning saying that non-btree indexes are not necessarily
> transactionally safe in the event of a crash.
As of 8.1, GIST indexes are WAL-logged, so that would be inappropria
On Fri, 2005-08-26 at 05:59, RAJU kumar wrote:
>
>
> i want to find out the difference between the btree index and hash
> index and how exactly the hash index work.
How do hash indexes work in postgresql? Poorly. badumpbump. Thanks,
I'll be here all week (bad western humor, sorry.)
Serio
On Tue, Aug 30, 2005 at 09:26:16 -0400,
jose fuenmayor <[EMAIL PROTECTED]> wrote:
> i waited like 11 hours and it doesn't finish, where is the FSM setting
> postgreSQL.conf?
http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-RESOURCE
---(end of
On Sun, 2005-08-21 at 16:16, Dan wrote:
> Hello,
>
>
>
> We have upgraded our PostgreSQL database version from 7.3.1 (Cygwin)
> under Windows 2000 server to v8.03 for windows.
>
>
>
> Now we dumped our database (app. size 6 GB) with PgAdmin III with
> success. The problem now is that we ca
I have data in one table called articles and I would like to make a
function in which takes certain data from it and display the results.
Example:
CREATE TABLE articles (
article_id serial,
title varchar(200),
posted timestamp,
article_subject varchar(200),
article_body text,
allow_comments boole
My install using the new driver (ODBC) seems to have helped
me a great deal.
Unfortunately one of my night jobs uses a dynamic cube
product that does a record set.
I am not certain but I have the feeling it is leaving the
connection open.
After a few days (always at night when the progra
On Tue, Aug 30, 2005 at 09:01:36AM -0500, Thomas F. O'Connell wrote:
> On Aug 29, 2005, at 2:19 PM, andy rost wrote:
> >
> >$declare loop1 cursor with hold for
> >select distinct ( tabname )
> >from meta ;
> >
> >results in sqlca.sqlcode = 100 and sqlca.sqlstate = '02000'
>
> [snip]
>
>
On Tue, Aug 30, 2005 at 12:15:54PM -0400, Postgres Admin wrote:
>
> Can I do something like this:
It's good that you gave an example, but it would also be good to
give a summary of what you're trying to do and what trouble you're
having so people don't have to guess.
> CREATE TABLE sample (id SER
Can I do something like this:
CREATE TABLE sample (id SERIAL, node INTEGER, parent INTEGER);
INSERT INTO sample(node,parent) VALUES(1,0);
INSERT INTO sample(node,parent) VALUES(2,0);
INSERT INTO sample(node,parent) VALUES(3,1);
INSERT INTO sample(node,parent) VALUES(4,3)
CREATE OR REPLACE FUNCTIO
On Aug 29, 2005, at 2:19 PM, andy rost wrote:
I'm new to the PostgreSQL community so please pardon what is
probably a silly question ...
I'm in the process of porting Informix ESQL to PostgreSQL. I
occasionally get sqlcode = 100 and sqlstate = 02000 when declaring
cursors or freeing prep
i waited like 11 hours and it doesn't finish, where is the FSM setting postgreSQL.conf?On 8/30/05, Bruno Wolff III <
[EMAIL PROTECTED]> wrote:On Tue, Aug 30, 2005 at 08:38:03 -0400, jose fuenmayor <
[EMAIL PROTECTED]> wrote:> i am using postgreSql 8.0.3 i've try vacuum "vacuum full" the hole datab
Unsubscribe
MESSAGE CONFIDENTIALITY AND SECURITY NOTICE.
This message or/and its attached files may contain information that are privileged and classified. In case you received it in error, without you being the intended recipient, please delete it immediately from your system
On Tue, Aug 30, 2005 at 08:38:03 -0400,
jose fuenmayor <[EMAIL PROTECTED]> wrote:
> i am using postgreSql 8.0.3 i've try vacuum "vacuum full" the hole database
> but it takes too long, seems it will never be finished, i've tried "vacuum
> " and the table remains nearly the same as isee i my PGD
i am using postgreSql 8.0.3 i've try vacuum "vacuum full" the
hole database but it takes too long, seems it will never be finished,
i've tried "vacuum " and the table remains nearly the
same as isee i my PGDATA directory. is this normal? . is there
something i can do ?On 8/25/05, Bruno Wolff III <
Unsubscribe
Thanks !
It sounds like Pink Floyd :)
I got two "stupid" questions:
- I would like to compare 2 DB (number of tables, numbers of records).
Is there a command to perform this ?
- I would to synchrinize these 2 DB, how could I do that easily ? Maybe
with 'WAL' but I cannot figure out how .
Hi every one
This is the first mail after registration;
It 's a test !!
thx
Cédric
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
32 matches
Mail list logo
