Re: [ADMIN] Statistical Reporting

"Dennis Oudijk" <[EMAIL PROTECTED]> wrote: > We run an apartment rental websites where people can post the rental > properties that are available to rent. > > We currently have a statistics feature that provides landlords with > information such as 'how many time has their property come up in a sea

Re: [ADMIN] Report Generator Proposal

"Mauricio de Castro" <[EMAIL PROTECTED]> wrote: > Report Generator in PHP-GTK that work with Pear-db. It's very easy for > users... I was thinking to generate the report with the psql, not with an external program, somethink like this: Welcome to psql 7.X, the PostgreSQL interactive terminal. T

[ADMIN] New file system based on Postgres

http://developers.slashdot.org/article.pl?sid=03/09/05/1241235&mode=thread&tid=131&tid=137&tid=189&tid=198 Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/

Re: [ADMIN] Need Help on query tuning

""Somasekhar Bangalore"" <[EMAIL PROTECTED]> wrote: >Hi, >I am having 7.2.3 version of postgres database. I have huge data in my database. I have a couple of views and >functions used in the application.if i run the views. The views take a long time to get the data. I am joining just 4 >tables nam

Re: [ADMIN] Explicit Cast

"Rhaoni Chiu Pereira" <[EMAIL PROTECTED]> wrote: > Hi List, > > As I already said .. I'm porting an Oracle DB to PostgreSQL and I must > rewrite most of the functions . So I have a problem to do something like this: > > ... atual_fatura in(''+'',''-'') ... > > It gives me the following error:

Re: [ADMIN] get current queries

""Ramil Sagum"" <[EMAIL PROTECTED]> wrote: > > > is there any way to see what statements/queries are currently being passed > on to the database? select * from pg_stat_activity; Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe

[ADMIN] where is pg_autovacuum ?

Hi, I used to install postgres 7.3.3 from RPM, today I needed to take a look at pg_utovacuum but I didn't find it ? Should I download it from somewhere else ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our exte

[ADMIN] pg_autovacuum ?

Hi, I used to install postgres 7.3.3 from RPM, today I needed to take a look at pg_utovacuum but I didn't find it ? Should I download it somewhere else ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe comm

Re: [ADMIN] concat_ws

"Tom Lane" <[EMAIL PROTECTED]> wrote: > Joe Conway <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> It seems to be running out of memory. > > > Also worth noting, without STRICT, even a plain EXPLAIN *without* > > ANALYZE causes the problem to show itself. > > Yeah. The problem is that the

Re: [ADMIN] Wrong plan or what ?

""HansH"" <[EMAIL PROTECTED]> > In response to "Mendola Gaetano": > > I'm running Postgres7.3.3 and I'm performing this simple select: > > Looking at your fast three step plan > > SELECT id_class from class_default where id_prov

Re: [ADMIN] parallel regression test failure

"Bruce Momjian" <[EMAIL PROTECTED]> wrote: > Tom Lane wrote: > > We need to think about whether this bug is serious enough to justify a > > quick 7.3.5 release. I'm leaning to the idea that it is not, because > > if it were, we'd have heard about it from the field before now. In > > pre-7.4 code

Re: [ADMIN] Postgres db corrupted ?

"Tom Lane" <[EMAIL PROTECTED]> wrote: > "Mendola Gaetano" <[EMAIL PROTECTED]> writes: > > "Tom Lane" <[EMAIL PROTECTED]> > >> Nope. I don't know how John got into this state, but it most definitely > >> was not that

Re: [ADMIN] Partition DB Tables by month

"Dani Oderbolz" <[EMAIL PROTECTED]> wrote: > Mendola Gaetano wrote: > > >you can easilly accomplish this using a partial index. > > > > > Would that really work with a view? > Can you post a syntax example for this? CREATE TABLE foo ( field_a field_b

Re: [ADMIN] Postgres db corrupted ?

"Tom Lane" <[EMAIL PROTECTED]> > "Mendola Gaetano" <[EMAIL PROTECTED]> writes: > > ""John P. Looney"" <[EMAIL PROTECTED]> writes: > >> bbadmin | | SQL_ASCII > > > For sure a way to obtain

Re: [ADMIN] OID's

""Marvin"" <[EMAIL PROTECTED]> wrote: > Somebody can tell me what's the difference on create the tables WITH OIDS > or without them??? > Thank you for ANY comments, Matter of space for example, anyway some times have a OIDS column can help you ( like to know the last row inserted ). Regards Gae

Re: [ADMIN] Partition DB Tables by month

"Dani Oderbolz" <[EMAIL PROTECTED]> wrote: > Ray Ontko wrote: > > >One limitation to the UNION approach is that you can't > >insert, update, or delete through the UNION view. At > >some point the application needs to understand how the > >virtual table is partitioned into these month-specific >

Re: [ADMIN] Postgres db corrupted ?

""John P. Looney"" <[EMAIL PROTECTED]> writes: > bbadmin | | SQL_ASCII For sure a way to obtain this inconsistence is delete the owner of a db and voila' a DB result to have no owner. May be is a good idea that the user postgres adopt these orfan DB. Regards Gaetano Mend

[ADMIN] 7.3.4 RPM ready for RH 7.1 and RH 7.2

Hi all, I builed the rpm 7.3.4 for RH7.1 and RH7.2 if anyone is interested let me know. Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [ADMIN] storage calculations

<[EMAIL PROTECTED]> writes: > i've been browsing the documentation online, and i can't > find where the storage layouts for tables and indexes are > explained. > > i'd like to be able to figure out, given a table or two > with a simple schema (no ineritance) and some indexes, and > a number of row

Re: [ADMIN] syslog enabled causes random hangs?

""Arthur Ward"" <[EMAIL PROTECTED]> writes: > I'm encountering strange hangs in postgresql backends at random moments. > They seem to be associated with attempts to issue log entries via syslog. > I have run backtraces on the hung backends a few times, and they routinely > trace into system librari

Re: [ADMIN] RPM for 7.3.4

"Lamar Owen" <[EMAIL PROTECTED]> wrote: > On Sunday 27 July 2003 16:46, Mendola Gaetano wrote: > > Hi all, > > is it in the plans the rpm building for this > > release? > > Yes. I have changed jobs; but I should have an RPMset by this evening. As >

[ADMIN] RPM for 7.3.4

Hi all, is it in the plans the rpm building for this release? Regards Gaetano Mendola ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] Release note missing

At the following link http://www.postgresql.org/docs/7.3/interactive/release.html are missing the release notes for 7.3.X Regards Gaetano Mendola ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] [PERFORM] Wrong plan or what ?

"Josh Berkus" <[EMAIL PROTECTED]> > Gaetano, > > > QUERY PLAN > > Hash Join (cost=265.64..32000.76 rows=40612 width=263) (actual > > time=11074.21..11134.28 rows=10 loops=1) > >Hash Cond: ("outer".id_user = "inner".id_user) > >-> Seq Scan on user_logs ul (cost=0.00..24932.65 rows=125896

Re: [ADMIN] [PERFORM] Wrong plan or what ?

Forget my PS to last message. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] [PERFORM] Wrong plan or what ?

"Josh Berkus" <[EMAIL PROTECTED]> > Gaetano, > > > SELECT * from user_logs where id_user in ( > > 10943, 10942, 10934, 10927, 10910, 10909 > > ); > > [SNIPPED] > > > Why the planner or the executor ( I don't know ) do not follow > > the same strategy ? > > It is, actually, according to th

[ADMIN] Wrong plan or what ?

Hi all, I'm running Postgres7.3.3 and I'm performing this simple select: select * from user_logs ul, user_data ud, class_default cd where ul.id_user = ud.id_user and ud.id_class = cd.id_class and cd.id_provider = 39; these are the number of rows for each table: user_logs

[ADMIN] news.us.postgresql.org

Hi all, Are the messages posted to this new server sended to mailing list too ? Thank you Gaetano ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] Database growth problem

"mlaks" <[EMAIL PROTECTED]> wrote: > But I run vaccuum analyze at the same frequency as on the PC's? How is it that > deleting and saving and vacuum analyze doesnt keep it at a normal svelte <1Gb > in size? > > What should I do to shrink it back down to its normal svelte shape? Did you try to vac

[ADMIN] News server

I see that news server ( I think is the best way to participate at the discussion ) is definitively down, do you need help on this side to push it again up ? I can ask to the company for which I work to put a news server working for us. Let me know. Gaetano ---(end of

[ADMIN] Interesting article

May wrap: http://www.hughdarwen.freeola.com/TheThirdManifesto.web/Missing-info-without-nulls.pdf Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [ADMIN] Function immutable is not during a reindex ?

"Tom Lane" <[EMAIL PROTECTED]> wrote: > "Mendola Gaetano" <[EMAIL PROTECTED]> writes: > > #\d t_a > > Table "public.t_a" > > Column | Type | Modifiers > > +-+--- > > a | integer | &

Re: [ADMIN] Function immutable is not during a reindex ?

On: Sunday, July 13, 2003 4:19 AM "Tom Lane" <[EMAIL PROTECTED]> wrote: > "Mendola Gaetano" <[EMAIL PROTECTED]> writes: > > the function is immutable but is executed 3 times > > ( one for each row). > > So? Sounds to me like it's work

[ADMIN] Function immutable is not during a reindex ?

Hi all, I'm running the followin example on Postgres 7.3.3 I notice that if I declare an immutable function like this: CREATE OR REPLACE FUNCTION test (integer) RETURNS integer AS ' declare begin raise notice ''test called''; return $1+1; end;' LANGUAGE plpgsql IMMUTABLE; and I use this func

Re: [ADMIN] Installazione Postgres

"Monica Robustelli" <[EMAIL PROTECTED]> wrote in Italia: > Ho installato Postgres 7.3.2 su macchina Red Hat 9! > Ho configurato Apache a php correttamente, senza alcun errore! > Adesso non riesco a far comunicare il php con Postgres, ho un errore sulla > connessione! > Questo dipende dalla configur

Re: [ADMIN] Renaming a DB

<[EMAIL PROTECTED]> wrote: > Hi, > > I have in my logs the following lines : > > jui 7 10:40:07 poseidon logger: FATAL: Non-superuser connection > limit exceeded > jui 7 10:40:44 poseidon logger: LOG: pq_recvbuf: unexpected EOF > on client connection > jui 7 10:40:53 poseidon last message re

Re: [ADMIN] Renaming a DB

"Tom Lane" <[EMAIL PROTECTED]> wrote: > "Mendola Gaetano" <[EMAIL PROTECTED]> writes: > > I'm running a Postgres 7.3.3 and I had the necessity to > > rename a DB, I did this by updating the pg_database > > table. > > If I perform ps

[ADMIN] Renaming a DB

Hi all, I'm running a Postgres 7.3.3 and I had the necessity to rename a DB, I did this by updating the pg_database table. If I perform psql -l I'm able to see that is reported the correct name ( I guess because a select on pg_database table is performed ) but if I try to connect to the DB after t

Re: [ADMIN] pg_dump trunc some rows

On: Friday, July 04, 2003 6:46 PM "myself" wrote: > Hi all, > I have a DB ( postgres 7.3.3 ) with encoding SQL_ASCII and in > some field I have strange character: > > # \encoding > SQL_ASCII > # select city, id_country from user_data where id_user = 4146; >city| id_country

[ADMIN] pg_dump trunc some rows

Hi all, I have a DB ( postgres 7.3.3 ) with encoding SQL_ASCII and in some field I have strange character: # \encoding SQL_ASCII # select city, id_country from user_data where id_user = 4146; city| id_country ---+ Serra de Outes - A Coruñ

[ADMIN] Postgres RoadMap

Hi all, Do we have a road map similar to this (MySql): http://www.databasejournal.com/features/mysql/article.php/2210771 ? I heard only about the point in time recovery in version 7.4, that's all, what about, for example, a "multi DB/HOST select" or the nested transactions ? Regards Gaetano --

[ADMIN] 7.4 Documetation

Hi all, on VIII. Appendixes of PostgreSQL 7.4devel Documentation is missing the release note of 7.3.3. Regards Gaetano. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[ADMIN] adddepend and contrib missing

Hi all, after installing Postgres7.3.3 on a RedHat 9.0 box ( I used the rpm ) I was looking for contrib/adddepend but is nowhere :-( Am I missing something? > locate adddepend /usr/share/doc/postgresql-contrib-7.3.3/README.adddepend no trace of the script!!! Thank you in advance Gaetano ---

Re: [ADMIN] Timestamp of insertion of the row.

"Anagha Joshi" <[EMAIL PROTECTED]> wrote: > Hi All, > I mean to say > Can I know the time when particular row is inserted into the table? i.e. > timestamp of insertion of row into the table. Is not clear what you want: # begin transaction;// 10:00:00 AM [ 3 minutes of delay ( com

Re: [ADMIN] Timestamp of insertion of the row.

"Bruno Wolff III" <[EMAIL PROTECTED]> wrote: > Mendola Gaetano <[EMAIL PROTECTED]> wrote: > > "Bruno Wolff III" <[EMAIL PROTECTED]> wrote: > > > You still may not want to use timeofday even for long transactions. > > > It depends

Re: [ADMIN] Timestamp of insertion of the row.

"Bruno Wolff III" <[EMAIL PROTECTED]> wrote: > You still may not want to use timeofday even for long transactions. > It depends on what the data really means to you. The OP was looking for a way to know the time of a row insertion, not the time of the transaction inside where the row was inserted

Re: [ADMIN] statistics question

"Sidar Lopez Cruz" <[EMAIL PROTECTED]> wrote: > can statistics help the postgresql performance? if yes how? What do you mean with "statistics" ? Anyway the planner use statistics information, collected by postgres statistics collector ( you should turn on it: stats_start_collector = true stats_re

Re: [ADMIN] Timestamp of insertion of the row.

"Henry House" <[EMAIL PROTECTED]> wrote: > Yes. Easy answer: use a column of type 'timestamp default now()'. With that default value you store the time stamp of transaction where the row was inserted. Immagine to insert inside the same transaction a lot of rows and this operation will take long 1

[ADMIN] Postgres 7.3.3 for Lamar Owen

I'm writing here because I can not reach directly Lamar Owen and he is waiting an url for Postgres 7.3.2 for RH7.2. Gaetano ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [E

Re: [ADMIN] How can I recover a 6.5.2 databases in a 7.3.3 database without dump files ?

"Bruno BAGUETTE" <[EMAIL PROTECTED]> wrote: > If Yes, where can I find the 6.5 PostgreSQL tar.gz ? ftp://ftp.fr.postgresql.org/source/v6.5/ Regards Gaetano ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropri

Re: [ADMIN] Timestamp of insertion of the row.

"Anagha Joshi" <[EMAIL PROTECTED]> wrote: > Hi, > Is there any way to know data & time when the row is inserted into a > table? You should define a supplementary field with default value "now()" this field will contain the transaction start time, if you want have the real time (if you insert a mi

Re: [ADMIN] Syncing DBs prior to RServ replication

"Michael A Nachbaur" <[EMAIL PROTECTED]> wrote: > I'm looking at syncronizing two database servers with RServ (production / "hot > standby"), and I'm trying to figure out a way to get the initial database on > the slave server syncronized with the master. > > Normally, I would 1) turn off all clien

Re: [ADMIN] What could be the problem?

"Rafael Mauricio González Palacios" <[EMAIL PROTECTED]> wrote: > Hello. > > We had a very serious trouble last week with our databases in Postgres and we > wanna know if maybe someone can help us to find the problem. > > The trouble was that a day some databases in Postgres appear without any row >

Re: [ADMIN] Diagnose Database Corruption

"Bruce Momjian" <[EMAIL PROTECTED]> wrote: > We don't have a checker because if it is corrupt, it will mention > something in the server logs or correct it automatically. Corruption is > very rare, usually hardware flakiness. I agree about the fact that corruption is very rare but sometimes I got

Re: [ADMIN] Help! Error when calling a function

"Ben Schneider" <[EMAIL PROTECTED]> wrote: > I am receiving the following error when I call a simple function: > Warning: pg_exec() [function.pg-exec > ]: Query failed: ERROR: fmgr_info: function 3036754: cache lookup failed . > in /var/www/html/cmwareben/db

Re: [ADMIN] DUMPall PG7.1.3 restore to PG7.3.2

"Eko Pranoto" <[EMAIL PROTECTED]> wrote: > I have error when restoring file DUMPall PG7.1.3 to > PG7.3.2 > with error message "function varchar(integer) does not > exist" > > any one can help ? Postgres 7.3.X is missing of a lot implicit cast present before so I suggest you to define your c

Re: [ADMIN] Disk I/O Monitoring

wrote "Kris Kiger" <[EMAIL PROTECTED]> > Hi all, I'm looking for a good way to monitor disk I/O on a linux > system. Specifically, I would like to know when postgres is making > page-ins and page-outs. If anyone knows of a good utility, please let > me know! Thank you for the help try iosta

Re: [ADMIN] Backup and Restore

"Jonathan Gardner" <[EMAIL PROTECTED]> wrote: > This is also a cheap way to "vacuum" the database: > > # pg_dump | gzip > dump.gz > # dropdb > # createdb > # gunzip -c dump.gz > psql Yes specially when you have a dump of about 1 GB and you manage a service 24/24 7/7!! The only cheap way to v

Re: [ADMIN] Backup and Restore

This is a well known issue, you can change Postgress version to 7.3.3 and the pg_dump on that version is more smart. Gaetano - Original Message - From: "David A. Leedom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 05, 2003 1:56 PM Subject: [ADMIN] Backup and Restore

[ADMIN] HOWTO: Postgres 7.3.3 on RedHat 7.2

Hi all, I tried to recompile Postgres 7.3.3 on a RedHat 7.2 ( rpm --rebuild postgresql-7.3.3-1PGDG.src.rpm ) and this fail because autoconf 2.53 is required, looking around for the autoconf 2.53 you'll find that is available ( in rpm format) only for RH 8.0. I was able to recompile the postgres 7