[GENERAL] pg_audit_users - Auditing user activity

but I'll test 9.3 and 9.4 soon. Thanks Pierre pg_audit_users-0.1.tar.bz2 Description: application/bzip-compressed-tar signature.asc Description: This is a digitally signed message part.

[GENERAL] my-post-engine, let's make MySQL speak to PostgreSQL

Hello I just "released" (aka made known to more people than me and my desk-neighboors) a tiny tool that may come handy to some people. It's a MySQL "plugin" (their definition of plugin is flabbergasting) that provides a postgres storage engine in a MySQL instance. It's usable both for select/up

[GENERAL] FTS query, statistics and planner estimations…

Hello I recently stumbled on a slow query in my database that showed an odd behaviour related to the statistics of FTS queries. The query does a few joins «after» running a FTS query on a main table. The FTS query returns a few thousand rows, but the estimations are wrong, leading the optimizer

Re: [GENERAL] FTS query, statistics and planner estimations…

On Wednesday, November 9, 2016 1:01:29 PM CET you wrote: > Hello, > > On 09.11.2016 12:22, Pierre Ducroquet wrote: > > Hello > > > > I recently stumbled on a slow query in my database that showed an odd > > behaviour related to the statistics of FTS queries. >

Re: [GENERAL] Re: [GENERAL] FTS query, statistics and planner estimations…

On Wednesday, November 9, 2016 10:51:11 AM CET Pavel Stehule wrote: > 2016-11-09 10:40 GMT+01:00 Francisco Olarte : > > Pierre: > > > > On Wed, Nov 9, 2016 at 10:22 AM, Pierre Ducroquet > > > > wrote: > > > The query does a few joins «after» running

Re: [GENERAL] FTS query, statistics and planner estimations…

On Wednesday, November 9, 2016 10:40:10 AM CET Francisco Olarte wrote: > Pierre: > > On Wed, Nov 9, 2016 at 10:22 AM, Pierre Ducroquet > > wrote: > > The query does a few joins «after» running a FTS query on a main table. > > The FTS query returns a few thousand ro

[GENERAL] PostgreSQL not reusing free space in table ?

PostgreSQL would use the free space to put the new data, so my update loop would give me a clean, «packed» table. What behaviour did I miss here ? How can I get PostgreSQL to use that free space without falling back to a vacuum full ? (And without using tools like pg_repack if possible, because this seems like not needed in that situation) Thanks Pierre signature.asc Description: This is a digitally signed message part.

Re: [GENERAL] PostgreSQL not reusing free space in table ?

On Friday, January 6, 2017 9:00:06 AM CET Merlin Moncure wrote: > On Fri, Jan 6, 2017 at 4:09 AM, Pierre Ducroquet > > wrote: > > Hi > > > > Running PostgreSQL 9.4, I am running in the following issue. > > On a huge table, I have to remove the content (set to &

Re: [GENERAL] Trouble installing postgresql server on Amazon Linux

Hello, Are u sur that it's not a network issue ? Maybe just try to telnet or check your ec2 security group. Pierre *Pierre HILBERT* *Database Responsible | Decatec* *Phone : +33 6 67 63 54 87* On Sun, Feb 7, 2016 at 10:35 PM, Augori wrote: > Thanks for the reply. Yes, it seems tha

Re: [GENERAL] Multi Master Replication setup

Hello, Searching BDR led me to a few surprising results... (trigrams definitely have numerous funny meanings ;o)) This URL will probably help: http://bdr-project.org/docs/stable/index.html Regards, Pierre Andreas Kretschmer a écrit : >Sachin Srivastava wrote: > >>

Re: [GENERAL] Share my experience and Thank you !

Hello, I think that you can safely add the PostgreSQL repository to your system, so that you can get the latest packages for your Debian. See there how to do it: https://wiki.postgresql.org/wiki/Apt Regards, Pierre Le 13 mai 2016 09:14:28 GMT+02:00, JingYuan Chen a écrit : >I use Deb

[GENERAL] varchar(n) VS text

Having read http://www.postgresql.org/docs/8.2/interactive/datatype-character.html I am puzzling over this issue: 1) Is there ever ANY reason to prefer "varchar(n)" to "text" as a column type? 2) For instance, if I know that a character-type column will never contain more than 300 characters, w

[GENERAL] Dynamic binding in plpgsql function

-This is what I need RETURN x; END; $$ LANGUAGE 'plpgsql'; I don't want to do an EXECUTE statement since I have no table to put after the FROM clause. I want to assign the resulting value directly to a variable like in my example. Can I/How can I achieve this? Thanks,

Re: [GENERAL] Dynamic binding in plpgsql function

Is EXECUTE slower than a direct assignment call? >-Original Message- >From: Vibhor Kumar [mailto:vibhor.ku...@enterprisedb.com] >Sent: 1 mars 2011 18:24 >To: Pierre Racine >Cc: pgsql-general@postgresql.org >Subject: Re: [GENERAL] Dynamic binding in plpgsql function >

[GENERAL] pg_audit_users - Auditing user activity

L 9.2 only, but I'll test 9.3 and 9.4 soon. Thanks Pierre pg_audit_users-0.1.tar.bz2 Description: application/bzip-compressed-tar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_audit_users - Auditing user activity

On Saturday, December 20, 2014 06:57:54 AM Adrian Klaver wrote: > On 12/20/2014 06:40 AM, Pierre Ducroquet wrote: > > Hi > > > > I'm working on a web credit card payment solution, so in a PCI-DSS > > environment, and the auditors gave me trouble with one

[GENERAL] Fwd: Ask for a question

Hi, Would you please tell me whether PostgreSQL can execute the following tasks? If not, please also tell me which one can help me for that. Thanks -- *謝宗翰* *|* *台北富邦銀行* *風險管理部* *| 10686**台北市大安區仁愛路四段**169**號**12**樓**| (02) 27716699 **分機* *62853* *Pierre

Re: [GENERAL] Fwd: Ask for a question

moving window function but also few logical rules. Please see details as following or attachment. I put some colors in rules. Hopefully, it's easier for you guys to read them. Thanks I really need the helps from your guys. Please give me some suggestions. Thanks. Pierre [image: Inline image 1

Re: [GENERAL] Fwd: Ask for a question

Hi Raymond, Thanks for your reply. Please see detail as following. Thanks again. Pierre [image: Inline image 1] On Thu, Jan 22, 2015 at 1:48 AM, Raymond O'Donnell wrote: > On 21/01/2015 17:32, Pierre Hsieh wrote: > > Hi guys, > > > > Thanks for your replies. > &

Re: [GENERAL] Fwd: Ask for a question

rice and the implied price from linear regression by each 250 historical data(moving window) Hopefully, it's clear for you to understand this calculation. Thanks [image: Inline image 1] On Thu, Jan 22, 2015 at 2:15 AM, Paul Jungwirth wrote: > Hi Pierre, > > It looks like you'

[GENERAL] How to create a specific table

Hi, Is there anyone who can help me to create a specific table as following? Thanks Pierre rule: 1. just one column which type is integer in table 2. this columns only has 1 and 2 for 50 times as following 1 2 1 2 1 2 1 2 .

[GENERAL] how to calculate standard deviation from a table

Hi This table just has a column which type is integer. There are one million data in this table. I wanna calculate standard deviation on each 50 data by order. It means SD1 is from data 1 to data 50, SD2 is from data 51 to 100 Is there anyone who can give me some suggestions? Thanks Pierre

[GENERAL] How to recover my postgres database ?

I have broken my postgres database by typing : psql How can I safely repair, knowing that I have the pg_dumpall of last night, but many dbs have changed today... ? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] How to recover my postgres database ?

On 05/11/2017 07:07 PM, Hunley, Douglas wrote: On Thu, May 11, 2017 at 11:53 AM, Pierre Couderc <mailto:pie...@couderc.eu>> wrote: How can I safely repair, knowing that I have the pg_dumpall of last night, but many dbs have changed today... ? If pg_dumpall is your on

Re: [GENERAL] How to recover my postgres database ?

On 05/11/2017 07:10 PM, John R Pierce wrote: On 5/11/2017 9:53 AM, Pierre Couderc wrote: I have broken my postgres database by typing : psql How can I safely repair, knowing that I have the pg_dumpall of last night, but many dbs have changed today... ? Thanks in advance was there

[GENERAL] Invalidation of cached plans for stored procedures ?

Hi On our production database, we had a small hiccup when playing a SQL migration. We write them to be as smooth as possible, trying not to interfere with running services, but this time, we got a batch of failures. I diagnosed the situation, and found out that we were hit by a known "feature"

[GENERAL] 8.3: where's the replacement tsearch2 module?

I just downloaded the 8.3 Windows installation (binary with installer). My database uses tsearch2. I was about to follow the conversions instructions found at Appendix F31 (on the new tsearch module). http://www.postgresql.org/docs/8.3/static/tsearch2.html However, I hit a problem when I get to

Re: [GENERAL] 8.3: where's the replacement tsearch2 module?

> > My database uses tsearch2. I was about to follow the conversions > > instructions found at Appendix F31 (on the new tsearch module). > > http://www.postgresql.org/docs/8.3/static/tsearch2.html > The docs will need to be updated because tsearch2 is now in the core and > should already be availa

[GENERAL] How to sort strings containing a dot?

Hello, I want to sort strings containing a dot but by taking care of this dot like any other character. example : Currently, I get this after the sort : co.aaa co.abb co.cab com co.ment com.enta But I would like to get this : co.aaa co.abb co.cab co.ment com com.enta How I can do this? Thank

Re: [GENERAL] How to sort strings containing a dot?

to t values ('co.cab'); > insert into t values ('com'); > insert into t values ('co.ment'); > insert into t values ('com.enta'); > > select name from t order by replace(name, '.', ''); > > > Jon > >> ---

Re: [GENERAL] How to sort strings containing a dot?

; > select name from t order by replace(name, '.', ''); > > > Jon > >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:pgsql-general- >> [EMAIL PROTECTED] On Behalf Of Pierre LEBRECH >> Sent: Tuesday, March 25, 2008 9:56 AM >> To

Re: [GENERAL] How to sort strings containing a dot?

Thanks Adam. No, It doesn't. But I have found a solution which works : select name from (select distinct name from t) as name order by replace(name, '.', 'a'); name -- co.aaa co.abb co.cab co.ment com com.enta (6 lines) Thanks to all of you. Adam Rich wrote : >> By the way,

[GENERAL] tsearch strategy for incremental search

I am trying to implement an incremental search engine. The service should start searching when the user has typed at least 3 characters. I am thinking of using the following strategy: a) Create a function string_to_three_char_tsvector(str text) that would generate the tsvector composed of the thr

Re: [GENERAL] tsearch strategy for incremental search

2008/6/30 Oleg Bartunov <[EMAIL PROTECTED]>: > tsearch will have prefix search support in 8.4. Thanks Oleg! That's fantastic news! In the meantime, carrying on with my earlier idea, here's the little function I came up with for extracting the 3-char-lexeme tsvector, in case anyone's interested:

Re: [GENERAL] locating cities within a radius of another

, orig.latitude), ST_MakePoint(dest.longitude, dest.latitude), 2) AND orig.id = 378 AND dest.id <> 378 Pierre >-Original Message- >From: pgsql-general-ow...@postgresql.org >[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joe >Conway >Sent: 21 juillet 2010 11

Re: [GENERAL] locating cities within a radius of another

Hum right... Better follow Paul instructions. We are in geographic coordinates here... Sorry. This would work in a limited projected space. >-Original Message- >From: pgsql-general-ow...@postgresql.org >[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of >Pierre Raci

[GENERAL] Dynamic data model, locks and performance

mapping correctly the files with the file system? Is Posgresql able to handle this kind of charge? -- A+ - Pierre

Re: [GENERAL] Dynamic data model, locks and performance

2010/7/28 Craig Ringer > On 29/07/10 07:06, Pierre Thibault wrote: > I doubt anyone can make any useful recommendations without a more > complete explanation of what you're trying to achieve and why you want > to do what you have described. > Thank you Craig, Yes, I was

Re: [GENERAL] tsearch strategy for incremental search

2008/6/30 Oleg Bartunov <[EMAIL PROTECTED]>: > you, probably, can use custom configuration, which uses pg_3chars > dictionary. Thanks Oleg. That sounds like a cleverer (and more natural) idea than mine. I am intrigued: is "pg_3chars" something that's part of the current distribution of postgres

[GENERAL] Getting several columns from subselect with LIMIT 1

I have a PERSONS table. I also have a PROGENY table, which is a many-to-many association table with two foreign keys to the PERSONS table to itself. (In this day and age, not only can an individual have any number of children, but also a person can have any number of parents! At least, let's assum

Fwd: [GENERAL] Getting several columns from subselect with LIMIT 1

Thanks for the suggestion. Unfortunately I get an INVALID COLUMN REFERENCE (SQL state: 42P10) to the effect that the subselect in the FROM clause cannot reference other tables at the same request level. 2008/9/20 Marcus Engene <[EMAIL PROTECTED]>: >> >> SELECT >>persons.*, >>( >>

Re: [GENERAL] dynamic crosstab

, that would be just super! A+ Pierre -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] dynamic crosstab

bash: ERREUR: : commande introuvable bash: » : commande introuvable pie...@duran:~$ LIGNE 4 : 'value_num'); bash: Erreur de syntaxe près du symbole inattendu « ) » pie...@duran:~$ ^ bash: ^ : commande introuvable (sorry about the French!) I could not do t

Re: [GENERAL] dynamic crosstab

ppily to their m$-access, therefore ignoring the pure wealth of postgreSQL: sad, isn't it?... A+ Pierre -- ________ Pierre Chevalier Mesté Duran 32100 Condom Tél+fax :09 75 27 45 62 05 62 28 06 83

Re: [GENERAL] dynamic crosstab

r_to_dataset() should be written, in C if I understand well. I have to dig out my old C book, and browse through postgresql APIs, code examples,etc. I guess... A+ Pierre -- ____ Pierre Chevalier Mesté Duran 3

Re: [GENERAL] dynamic crosstab

t could be for any FLOSS database, I guess) could be developed: again, does someone know if such a project exists? -- Pierre Chevalier Mesté Duran 32100 Condom Tél : 09 75 27 45 62 - 06 37 80 33 64 http://pierremariechevalier.free.fr/ Logiciels Libres dans le Gers: http://gnusquetair

Re: [GENERAL] dynamic crosstab

ually, I would have liked to have something that I can reuse within postgresql, just like a view. Sorry, I'm an idealist... based on any resultset (any number of columns). I'd be happy to post a little get you started code if you wanted. Sure, why not? Thanks! -- Pierre Chevalie

Re: [GENERAL] dynamic crosstab

t[7] in join or string at ./crosstab_perl.pl line 24. ... But the .csv file is there, after a redirection, and it seems fine! I'm just worried about the messages: anything serious, or can I just ignore them? I'll do a diff with the csv I generated before (with psql, \a, and so

[GENERAL] Keeping only one postgres.exe instance running

Hi, Is there a way to tell PostgreSQL to keep only one instance of postgres.exe running? Thanks, Pierre -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] HELP - Recover function delete

threw away by mistake... Pierre ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[GENERAL] tsearch2, locale, UTF-8 and Windows

Over the past few days, I have been reading everything I could about tsearch2, but I cannot figure out what the latest status is concerning the "default locale" on a Windows UTF-8 database under PostgreSQL 8.2. More specifically, I have a UTF-8 database containing information in five different Eu

Re: [GENERAL] tsearch2, locale, UTF-8 and Windows

ges (see quoted post below), I don't know on what factor to base my choice of initdb locale. Suggestions? On Jan 28, 3:28 am, [EMAIL PROTECTED] ("Pierre Thibaudeau") wrote: [...] I cannot figure out what the latest status is concerning the "default locale" on a Windows UTF-8

[GENERAL] convert(USING utf8_to_iso_8859_15) on Windows

Is this a documented phenomenon with the "convert" function? The first result is what's expected: SELECT convert('Gregoire' USING utf8_to_iso_8859_15); "Gregoire" But I don't understand the next result, when I put an acute accent over the first "e": SELECT convert('Grégoire' USING utf8_to_iso_

Fwd: [GENERAL] convert(USING utf8_to_iso_8859_15) on Windows

rks with UTF8, via the ODBC driver. Say again that I output the data with another software that expects UTF8, via the JDBC driver. Why does it matter that my system should be localized in another encoding? 2007/1/29, Tom Lane <[EMAIL PROTECTED]>: "Pierre Thibaudeau" <[EMAIL

[GENERAL] "simple" dict with stop words in tsearch2

In tsearch2, I would like to use the "simple" dictionary along with my own list of stopwords. In other words, once the text is parsed into tokens, no stemming whatsoever, but stopwords are removed. Is there an easy way to produce that result, using the standard "simple" dictionary?

Re: [GENERAL] "simple" dict with stop words in tsearch2

Brilliant! Thank you! > In tsearch2, I would like to use the "simple" dictionary along with my > own list of stopwords. > [...] sure, just specify dict_initoption. For example, test=# update pg_ts_dict set dict_initoption='contrib/english.stop' where dict_name='simple'; UPDATE 1 test=# selec

[GENERAL] unsigned types, binary op. and cast pb

xadecimal values in postgresql. But as far as I have understand the discussions and the problem, it would be "difficult" to modify, at least, the internal N x N conversion table. So, is there any chance to see unsigned types in postgresql one day? and/or oxhhh notation? Sincerely, Pierr

Re: [GENERAL] PG vs MySQL

I am incline to unsuscribe, although it is a nice chanel to stay informed and continue to learn from other users experiences, but too much information kills information. All the best to the postgresql team, Pierre PS: I hope that my english is understable, and that I didn't hurt anybody with misund

[GENERAL] serious performance problem

Hi, I am running PGSql 7.0.3 over Linux 2/ELF with a ReiserFS filesystem, Bi-P3 800 and 2Gb of RAM. My database jump from 8 in load to 32 without any real reason nor too much requests. I already do vacuum even on the fly ifever that can decrease load, but nothing...

[GENERAL] postgres load

I republish my question for I had no answer, and this is a serious problem to me... I've used explain, vacuum, indexes... and so on, few nested requests... I am running PGSql 7.0.3 over Linux 2/ELF with a ReiserFS filesystem, Bi-P3 800 and 2Gb of RAM. My database jump from 8 in lo

[GENERAL] number of pgsql childrens

on my DB server I ave 245 "idle" postmasters process for 130 httpd persistant DB connections alive. can anyone give me a clue how to manage this number of unused/idles children and how to have them quickerly deallocated ? -- EDENJOB / APR-Job Email: [EMAIL PROTECTED]Home:

Re: [GENERAL] PostgreSQL vs Firebird SQL

ide of what I would call a horrible abuse; but despite these conditions, PostgreSQL did very well, there has never been any data loss, it was used daily for mission-critical operations. So there are my $0.02 And these were my small 0.02€ ;) À+ Pierre PS: sorry Chris, I didn't pay

Re: [GENERAL] PostgreSQL vs Firebird SQL

Le 10/02/2016 18:08, John R Pierce a écrit : On 2/10/2016 8:51 AM, Pierre Chevalier Géologue wrote: PPS: how should I behave on this list: should I systematically "reply to all", or just "reply" to the list? I'm used to a number of mailing lists where a simple "r

Re: [GENERAL] PostgreSQL vs Firebird SQL

matically to the list, I can see my own replies, displayed within the appropriate conversation thread. Or did I miss a point? À+ Pierre -- ____________ Pierre Chevalier PChGEI: Pierre Chevalier Géologue Et Informaticien M

Re: [GENERAL] recovering database from a linux file system

maybe other "details". Since postgresql data files are *very* close to what happens in the server's RAM, a $PGDATA contents will not be readable on a different architecture. Which OS was your old dusty server running on? Regards (

Re: [GENERAL] Enhancement request for pg_dump

pg_dump' didn't help. And as I can read this discussion (I haven't finished yet, obviously), this is not the case. À+ Pierre -- ____________ Pierre Chevalier PChGEI: Pierre Chevalier Géologue Et Informaticien Partenaire

Re: [GENERAL] Enhancement request for pg_dump

the idea should be a bit more matured first, maybe? À+ Pierre -- ____ Pierre Chevalier PChGEI: Pierre Chevalier Géologue Et Informaticien Partenaire DALIBO Mesté Duran 32100 Condom Tél+fax : 09 75 27 45 62

Re: [GENERAL] Enhancement request for pg_dump

alize there is pg_restore -l and pg_restore -L : http://www.postgresql.org/docs/9.5/interactive/app-pgrestore.html Yes, thanks for the advice. Now I remember that I had used it also: I just found these notes in my numeric attic: # pierre@autan: ~< 2013_08_17__17_00_23 > pg

Re: [GENERAL] Thoughts on "Love Your Database"

, and I tend to stuff more and more logic inside the database. Which is often merely converting SQL queries into views... But it comes with a counterpart: the more you put logic inside your DBMS, the more dependent you become. As far as I'm concerned, I recently decided to just stick to Po

Re: [GENERAL] Thoughts on "Love Your Database"

ode on the server. All right, I understand better now. I think I also totally missed your point, sorry... I'll give a look at andl. À+ Pierre -- ____ Pierre Chevalier PChGEI: Pierre Chevalier Géologue Et Informaticien Pa

Re: [GENERAL] Thoughts on "Love Your Database"

the 1990's, I met many-many deeply sick persons. I had been infected for a while, I must confess. À+ Pierre -- ________ Pierre Chevalier PChGEI: Pierre Chevalier Géologue Et Informaticien Partenaire DALIBO

Re: [GENERAL] Thoughts on "Love Your Database"

where you had something like 1 - 1 = 2... Maybe your boss was actually very wise (and paranoid)?... À+ Pierre -- ____ Pierre Chevalier PChGEI: Pierre Chevalier Géologue Et Informaticien Partenaire DALIBO Mesté Duran

Re: [GENERAL] Thoughts on "Love Your Database"

ould more suitable into "advocacy" than here in "general", though. À+ Pierre -- ________ Pierre Chevalier PChGEI: Pierre Chevalier Géologue Et Informaticien Partenaire DALIBO Mesté Duran 32100 Condom

Re: [GENERAL] Thoughts on "Love Your Database"

Hi, Le 17/05/2016 10:44, John R Pierce a écrit : On 5/17/2016 1:34 AM, Pierre Chevalier Géologue wrote: On this matter, I hear *very* often from such guys that the only reproach they have to PostgreSQL is that it does not come with a slick GUI like Access. Access is a lot more than a slick

Re: [GENERAL] Thoughts on "Love Your Database"

uot;application development". The latter would be made by using clipper, most often. À+ Pierre -- ____________ Pierre Chevalier PChGEI: Pierre Chevalier Géologue Et Informaticien Partenaire DALIBO Mesté Duran 32100 Condom

Re: [GENERAL] Thoughts on "Love Your Database"

Interesting point of view. Time to make a bug report, isn't it? ;-) À+ Pierre Le 18/05/2016 17:44, Adam Brusselback a écrit : On Tue, May 17, 2016 at 1:54 PM, Raymond O'Donnellmailto:r...@iol.ie>> wrote: Having said all that, I've rarely had any trouble with pgAdmin

Re: [GENERAL] Thoughts on "Love Your Database"

. À+ Pierre -- Pierre Chevalier PChGEI: Pierre Chevalier Géologue Et Informaticien Partenaire DALIBO Mesté Duran 32100 Condom Tél+fax :09 75 27 45 62 06 37 80 33 64 Émail

Re: [GENERAL] Thoughts on "Love Your Database"

that, neither a "SQL-only" fellow, nor a "C-what-else" guy. It also reminds me of a paper I read once, where it was carefully explained why scientists hated databases. But that's another subject. Le 04/05/2016 21:22, Will McCormick a écrit : Yeah but your alread

[Fwd: Re: [GENERAL] Autovacuum keeps vacuuming a table disabled in pg_autovacuum]

I stopped using autovacuum months ago because of similar problems (version 8.1.4). Because we do some major inserts and updates about four times a day, there were a few tables that I didn't want autovacuumed. Even after I turned autovacuum off for these tables it still tried to vacuum them whil

Re: [Fwd: Re: [GENERAL] Autovacuum keeps vacuuming a table disabled in pg_autovacuum]

Alvaro Herrera wrote: FYI, in 8.2 and up the Xid wraparound problem is considered on a table by table basis, which means that only the tables that have not been vacuumed recently need to be vacuumed. The need for database wide vacuuming is gone. That's good. Time to start VACUUM FULL ANAL

Re: [Fwd: Re: [GENERAL] Autovacuum keeps vacuuming a table disabled in pg_autovacuum]

Andrew Sullivan wrote: On Fri, Jun 01, 2007 at 01:27:14PM -0700, Ron St-Pierre wrote: imp=# select age(datfrozenxid) from pg_database where datname = 'imp'; age 1571381411 (1 row) Time to start VACUUM FULL ANALYZE over the weekend. I guess this come

Re: [GENERAL] Duplicate Unique Key constraint error

Harpreet Dhaliwal wrote: Hi, I keep getting this duplicate unique key constraint error for my primary key even though I'm not inserting anything duplicate. It even inserts the records properly but my console throws this error that I'm sure of what it is all about. Corruption of my Primary Ke

Re: [GENERAL] Debian problem...

There's likely someone here that can help you, if you can give us some more info. To start with, did the uninstall even work? Ron Tom Allison wrote: Ran into a problem. I hosed up postgresql by deleting the data directory. So I thought I would just uninstall and reinstall postgres using De

Re: [GENERAL]

carter ck wrote: > Hi all, > > I was trying to create function in postgres, but it returns error mentioning > the language is NOT defined. > > The function is as following: > > CREATE OR REPLACE FUNCTION test_word_count(TEXT, TEXT) RETURNS INTEGER AS $$ > DECLARE > d_word ALIAS FOR $1; > d_phras

Re: [GENERAL] getting list of tables from command line

Craig White wrote: I wrote a little script to individually back up table schemas, table data and then vacuum the table and it works nicely but I wanted a way to query a database and get a text file with just the table names and cannot figure out a way to do that. my script looks like this... (al

Re: [GENERAL] how to redirect output to a file

A. Kretschmer wrote: am Tue, dem 04.12.2007, um 20:19:29 -0800 mailte pc folgendes: Hi, How to redirect the output of an sql command to a file? Thanks in advance within psql you can use \o , from the shell you can use this: [EMAIL PROTECTED]:~$ echo "select now()" | psql test > now.

Re: [GENERAL] top posting

Thomas Hart wrote: Andrew Sullivan wrote: I don't think top posting is always the crime it's made to be (and I get a little tired of lectures to others about it on these lists). A I agree. Obviously there is convention, and I will post in the style generally accepted in the list, but to

[GENERAL] DBA Book - Not "postgresql book - practical or something newer?"

Unfortunately there isn't a current version of Joshua Drake's book out there (which I do own along with PostgreSQL Essential Reference by Stinson), so alternatively, can anyone recommend a good DBA book outlining best practices, physical design, etc? I would like something that is relevant to P

Re: [GENERAL] DBA Book - Not "postgresql book - practical or something newer?"

Olexandr Melnyk wrote: Joe Celko's "SQL Programming Style" is a good not vendor-specific book. As for PostgreSQL-specific books, I can only speak for one I read before: Bruce Momjian's "PostgreSQL: Introduction and Concepts". It is a good introductionary book, although it isn't based on Postgr

Re: [GENERAL] Fragments in tsearch2 headline

or pg. Pierre-yves. diff -Nrub postgresql-8.3.1-orig/contrib/tsearch2/tsearch2.c postgresql-8.3.1/contrib/tsearch2/tsearch2.c --- postgresql-8.3.1-orig/contrib/tsearch2/tsearch2.c 2008-01-01 20:45:45.0 +0100 +++ postgresql-8.3.1/contrib/tsearch2/tsearch2.c 2008-05-22 11:35:07.0 +0200 @@

Re: [GENERAL] Fragments in tsearch2 headline

On Fri, May 23, 2008 at 7:10 AM, Sushant Sinha <[EMAIL PROTECTED]> wrote: > Teodor did not want a separate function. He wanted it as an extension to > ts_headline. One way to do this will be to invoke it only when options > like MaxCoverSize is used. It will be slightly ugly though. What I underst

[GENERAL] could not select a suitable default timezone on Initdb, 8.3.3, Windows 2008 x64

ID AS '$libdir/ascii_and_mic', 'ascii_to_mic' LANGUAGE C STRICT; child process exited with exit code 1 The file ascii_and_mic.dll does exist in C:/Program Files (x86)/PostgreSQL/8.3/lib Thanks, Jean-Pierre Pelletier e-djuster -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Pattern Matching - Range of Letters

I'm sure that others have solved this but I can't find anything with my (google and archive) searches. I need to retrieve data where the text field is within a certain range e.g. A-An Am-Bc Bc-Eg Yi-Zz Does anyone know of a good approach to achieve this? Should I be looking into regular e

Re: [GENERAL] Pattern Matching - Range of Letters

Thanks Richard and Joshua, I had no idea that BETWEEN worked for text. SELECT * FROM Your_table AS YT WHERE YT.text_field BETWEEN 'Aa' AND 'An'; postgres=# select * from test where test between 'A' and 'An'; test -- A Ab Ac (3 rows) Ron Ron St

Re: [GENERAL] Pattern Matching - Range of Letters

'A' and test <'Am'; "A" "Ab" "Ac" select * from test where test >= 'Am' and test <'Bc'; "Amz" "Az" The end will be tricky because "" is not < "zz" so you will need the la

Re: [GENERAL] interfaces for python

I'd advise psycopg as the fastest one (by a factor of 10x on large selects). On Wed, 6 Oct 2004 21:13:02 -0700, Scott Frankel <[EMAIL PROTECTED]> wrote: I'd like to know if anyone has recommendations for which Python DB-API 2.0 interface to use with PostGreSQL-7.4.5. The database and tool

Re: [GENERAL] Reading a text file into PostgreSQL

Eyinagho Newton wrote: Hiya Everyone, Can anyone explain how postgreSQL reads from a text file into tables already created in PostgreSQL? I am also checking the thread in the Forum just to see if someone has written about it in the past. Thanks. Newton Do you mean when you read it in using the C

Re: [GENERAL] [NOVICE] Conditional Relationships?

John Browne wrote: Ok, I'm designing a new database for work, and I have run across a situation where a "conditional relationship" makes sense. Here is a *simplified* example of what I'm talking about: tb_address_data_us address_id addr1 addr2 city state zip_code tb_address_data_ca address_id addr

Re: [GENERAL] Online & update races

I used to do it this way : Suppose you have a web form to edit data from a table... you add a field in your table which contains a version identifier for that data, then you UPDATE ... WHERE ... AND version_id = the old version id. The version_id is passed around in a session variable or

Re: [GENERAL] delayed input

Use a cursor... I need to select all tuples from a table, but need them to be fetched with a constant delay (say 1 sec) between every consecutive tuples. The first idea that came up to my mind is to create a DelayedSeqScan operator, and put delay before returning the scanned tuple. Can

  1   2   3   >