> -Original Message-
> From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
> ow...@postgresql.org] On Behalf Of Viktor
> Sent: Wednesday, October 02, 2013 4:12 AM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Random server overload
>
> On 10/1/2
hr values are defaults.
>
> System:
> RAM 74 GB
> PostgreSQL 9.1.9, Debian 6
> Database size on disc: 84 GB data + 23 GB indexes. Different LVMs on RAID
> 10.
>
>
> --
> Best regards
Did you try using any kind of connection pooler, e.g. PgBouncer?
Should help.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
gsql,
not pure sql, could be used only inside plpgsql function in 8.3.
OTOH, starting with 9.0 you can use anonymous plpgsql blocks, and get what you
asked for.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
tovacuum workers you have? Does this long-running autovacuum
prevent other tables from being vacuumed in-time?
Is there some other long running transaction involving this table and
preventing autovacuum from doing its job?
Regards,
Igor Neyman
Regards,
--
Sent via pgsql-admin mailing list (p
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 2:50 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
Well, maybe I am.
But I am worried because I know that there are some tables that do lots of
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 2:24 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
I am using the defualt values for autovaccum.
How do you suggest to tune the autovacuum?
If the
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 12:04 PM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
I have some tables that I do a lot of updates, deletes and inserts.
So I am worried that my
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 11:10 AM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
Well, so I need to do reindex frequentely in database? Is that right?
Or should I use cluster, as
From: Rodrigo Barboza [mailto:rodrigombu...@gmail.com]
Sent: Thursday, May 30, 2013 10:42 AM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] How do I know my table is bloated?
On Thu, May 30, 2013 at 11:16 AM, Igor Neyman wrote:
From: pgsql-admin-ow...@postgresql.org
command and I read in the docs the
one reason to use reindex is when a table is bloated.
But how do I know when a table is bloated?
You could use PGSTATTUPLE extension, which you could read about here:
http://www.postgresql.org/docs/9.2/static/pgstattuple.html
Regards,
Igor Neyman
--
Sent via
ng a single SELECT or
> possibly read the data into a temporary table for processing?
>
> Regards,
> Ken
>
Hi Ken,
So, it means that number of (different) foreign tables joined in single select
cannot exceed 10, right?
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing
to your Postgres database.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
END IF;
RETURN NEW;
RAISE NOTICE 'gravado local!';
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION teste_after_insert()
OWNER TO postgres;
--
------
Thomaz Luiz Santos
Linux User: #359356
http://thomaz.santos.googlepages.c
From: Igor Neyman
Sent: Tuesday, November 06, 2012 4:09 PM
To: pgsql-admin@postgresql.org
Subject: unlooged tables
Hi,
Where in pg_catalog I can find, if the table was created as "unlogged" (or not)?
As in: create unlogged table t1(c1 int);
I can't seem to find this info in pg
Hi,
Where in pg_catalog I can find, if the table was created as "unlogged" (or not)?
As in: create unlogged table t1(c1 int);
I can't seem to find this info in pg_catalog tables/views.
Tried psql with -E to describe (\d) unlogged table, but it was not helpful.
Regards,
Igor Neyman
s in a very short
time, and start using them, while postponing to run "VALIDATE CONSTRAINT" for
later.
It's similar to Oracle's adding FK with "NOCHECK" option, but if IRC there is
no need to run "VALIDATE CONSTRAINT" later.
Regards,
Igor Neyman
--
Sent v
> Lutz
No, it is not possible.
But, inside log file you can use %d for "log_line_prefix" to specify
which db emitted particular line.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
ing GmbH http://www.bfk.de/
> Kriegsstraße 100 tel: +49-721-96201-1
> D-76133 Karlsruhe fax: +49-721-96201-99
PgBouncer is the easiest piece of software to install and to manage I've ever
dealt with, and it's very light on system resources.
Regards,
Ig
QL/8.4/data" -w
Could it be that account used to start PG service doesn't have
privileges to "run as a service"?
Check in "Local Security Settings" under "Local Policies"/"User Rights
Assignments" - make sure that "Log on as a service" grant
to
get SELECT privileges on data dictionary views.
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
]
You need to create "System Data Source" (or User) - not "File
Data Source".
Regards,
Igor Neyman
th the developers if you want to have reproduceable ddl
> changes in all your systems that match the code changes.
>
Completely agree with Scott.
Only want to add that in this kind of development environment:
development/test/production -
Source code versioning software is absolute necessity (there are many:
CSV, SourceSafe, Perforce, ... - pick your choice).
Regards,
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Do you have proper configuration (that allows network
connections) in your pg_hba.conf file?
Regards,
Igor Neyman
the change in
the original "filter" table, but also your history table "old_filter" should be
modified as well: new column should be added.
So, in short there is no "easy" way around.
When "source" table is modified, "destination" table and
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Tuesday, June 22, 2010 2:41 PM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> "Igor Neyman" writes:
> > Atta
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Tuesday, June 22, 2010 1:10 PM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> "Igor Neyman" writes:
> > Attac
> -Original Message-
> From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
> Sent: Tuesday, June 22, 2010 12:40 PM
> To: Igor Neyman; John Rouillard; Glyn Astill
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> -Original Message-
> From: Glyn Astill [mailto:glynast...@yahoo.co.uk]
> Sent: Tuesday, June 22, 2010 12:36 PM
> To: John Rouillard; Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> --- On Tue, 22/
> -Original Message-
> From: John Rouillard [mailto:rou...@renesys.com]
> Sent: Tuesday, June 22, 2010 11:52 AM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> On Tue, Jun 22, 2010 at 11:05:02AM
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Tuesday, June 22, 2010 10:37 AM
> To: Igor Neyman
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> "Igor Neyman" writes:
> &g
ot;old" backups (created with older pg_dump version)
is that I'm trying to save time during upgrade, and I have these big
backup files already created.
TIA,
Igor Neyman
28 May 2010 11:45:17 ο/η Ravi Katkar έγραψε:
> > Hi ,
> >
> > What is the Oracle's Long data type equivalent data type
> in Postgresql ?
> >
>
> int8 i guess
>
> > Regards,
> > Ravi katkar
> >
> >
> >
> >
>
>
tionality?
>
> Mike
>
Partition your MESSAGES table by week or month (read on table
partitioning in PG docs).
Pg_dump "old" purtitions from "current" server, when they are not needed
any more.
Move backups of dumped partitions to your "auxilary" server, and
pg_restore them there.
Igor Neyman
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Is there a document desribing (ar at least listing) new/obsolete
configuration parameters in postgresql.conf, when upgrading from version
to version?
Regards,
Igor Neyman
Hello,
Let's say TableA has "toastable" column, the contents of this column is
stored in let's say pg_toast_1234.
Is there a query to find which records (chunk_id, chunk_seq) in
pg_toast_1234 store data for specific record in TableA (i.e. with PK
column value eq. '567')?
Igor Neyman
When I run "VACUUM ANALYZE" (or "vacuumdb -z") on the database, how can
I exclude specific tables from being analyzed?
Igor
If you could declare a Foreign Key on two columns in "history" table
referencing "master" table, and declare this FK with "ON UPDATE CASCADE"
option, then postgres will update status in history table for you
whenever you update status in master table.
Igor
-Original Message-
From: [EMAIL
Read the docs on "connectby" function provided by "tablefunc" contrib
module.
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gibson
Chimhamhiwa
Sent: Friday, July 25, 2008 7:43 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Prent-Child r
First you get to Postgresql docs, from there you get anywhere you want.
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gibson
Chimhamhiwa
Sent: Wednesday, July 23, 2008 11:10 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Query a lis
First do:
DROP OWNED BY user1;
then:
drop role user1;
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rex Mabry
Sent: Tuesday, July 08, 2008 12:45 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] dropping a user in 8.2.6
I am using vers
"stats_start_collector" is an obsolete parameter in 8.3, that's why PG
wouldn't start with it.
Igor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of bogdad
Sent: Wednesday, July 02, 2008 2:38 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Postgres wind
I'm trying to install 8.3.1 (binaries) on Win2003 using windows
installer (msi).
I'm runnning silent install with:
ADDLOCAL=server,psql,pgadmin,psqlodbc,nls
and I'm getting error message saying, that "psqlodbc is not included in
the package".
When I exclude odbc:
ADDLOCAL=server,psql,pgad
I'm trying to install 8.3.1 (binaries) on Win2003 using windows
installer (msi).
I'm runnning silent install with:
ADDLOCAL=server,psql,pgadmin,psqlodbc,nls
and I'm getting error message saying, that "psqlodbc is not included in
the package".
When I exclude odbc:
ADDLOCAL=server,psql,pgadmi
Eric,
Don't be so defensive.
Here is an abstract from documentation:
"8.1.4. Serial Types
The data types serial and bigserial are not true types, but merely a
notational convenience for setting up unique identifier columns (similar
to the AUTO_INCREMENT property supported by some other databases
Yes, PG allows compound or composite keys for primary keys.
Igor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Carol Walter
Sent: Wednesday, September 19, 2007 10:37 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Primary key
Hello,
Does postgres
Why not use information_schema?
select prk.table_name AS PARENT_TABLE, prk.constraint_name AS PK,
tc.table_name AS CHILD_TABLE, refc.constraint_name AS FK
from information_schema.table_constraints prk,
information_schema.referential_constraints refc,
information_sche
It is called "update":
UPDATE SET = NULL, = NULL, =
NULL;
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of smiley2211
Sent: Thursday, August 09, 2007 10:27 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Delete COLUMN data
Hello all,
I need to D
Index will not be used if your string has "wild card" (%) in the
beginning.
It should be used, if you change your query to:
select *
from tb_gen_person
where pes_name like 'albert%';
Igor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alexander B.
Sent
ALTER TABLE tableName ADD CONSTRAINT pkname_pkey (column1, column2,
...);
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jessica Richard
Sent: Tuesday, July 17, 2007 2:44 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Can primary key be dropped
This document:
http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
could answer some of your questions.
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Tokmatchi
Sent: Monday, June 18, 2007 11:55 AM
To: [EMAIL PROTECTE
Look up dblink(...) function in PG documentation:
http://search.postgresql.org/search?u=%2Fdocs%2F8.2%2Fstatic%2F&q=dblink
Igor Neyman
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Raul Retamozo
Sent: Wednesday, June 06, 2007 7:09 P
More important question would be, why would you want to do this (change columns
order)?
I can't think of any valid reason for this.
Igor Neyman
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erwin
Brandstetter
Sent: Wednesday, June 06, 2007 11:
ID
AS $$ ' || exec_string || ' $$LANGUAGE PLPGSQL;' ;
PERFORM any_block();
RETURN TRUE;
END;
$THIS$LANGUAGE PLPGSQL;
to which I pass my "anonymous" block as a parameter.
As you can see, this function creates/replaces "on the fly" function
"any_block()" and
Lookup "dblink" in postgres documentation.
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 10:00 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Copying schemas between databases
Hi
Im us
Obviously, you are coming from "Oracle world. In PG according to:
http://www.postgresql.org/docs/current/static/errcodes-appendix.html
exception WHEN no_data THEN ...
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Karthikeyan
Sundaram
Se
Why wouldn't you look at the definition of the view which is based on
this table (and which you claim is still working), and how it references
basic table?
M.b. it'll point you to the actual table location.
Igor
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Beha
PM
To: Igor Neyman
Cc: Andy Shellam (Mailing Lists); pgsql-admin@postgresql.org
Subject: Re: [ADMIN] host name?
not sure how to resolve the name, but maybe this is close
enough:
select usename, client_addr from pg_catalog.pg_stat_activity;
On Mon, Feb 26, 2007 at 11:47:13AM -0500, Igor Neyman
Igor Neyman
Cc: Andy Shellam (Mailing Lists); pgsql-admin@postgresql.org
Subject: Re: [ADMIN] host name?
not sure how to resolve the name, but maybe this is close
enough:
select usename, client_addr from pg_catalog.pg_stat_activity;
On Mon, Feb 26, 2007 at 11:47:13AM -0500, Igor Neyman wrote:
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andy Shellam
(Mailing Lists)
Sent: Monday, February 26, 2007 10:56 AM
To: Igor Neyman
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] host name?
Igor Neyman wrote:
Is there a function (or catalog view) that I can
And one more question.
Is there a way (function/view) to find machine name on which user
program (connected to Postgres) runs?
Igor
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Igor Neyman
Sent: Monday, February 26, 2007 10:29 AM
To: pgsql
Is there a function (or catalog view) that I can call in psql and that
will tell me host name of the machine on which Postgres database is
running?
Igor
61 matches
Mail list logo
