Re: [GENERAL] Uploading data to postgresql database

On Tue, Mar 17, 2009 at 6:31 AM, Subha Ramakrishnan wrote: > I use postgresql 8.3.1 with postgis 1.3.3. Don't know about the other stuff, but is there a good reason you're running such an old release of 8.3? - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Question about Warm Standby

On Tue, 2009-03-17 at 17:59 -0700, Jack W wrote: > I set up a failover system with one primary server and one standby > server. > In the standby server's log, I saw the lines like below: > > Command for restore: copy "E:\archive\0001004C" > "pg_xlog\RECOVERYXLOG" > > The abo

Re: [GENERAL] PostgreSql with or without Plus?

On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote: > Postgres Plus does support Linux and it includes all the PostgreSQL > features as well as have many other additional useful features.One of > which is its dyna tune module. > You can check through the webpage > http://www.enterprised

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

At 10:00 PM 3/17/2009, Harald Armin Massa wrote: Merlin, > I agree though > that a single table approach is best unless 1) the table has to scale > to really, really large sizes or 2) there is a lot of churn on the > data (lots of bulk inserts and deletes). while agreeing, an additional questio

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

At 12:05 AM 3/18/2009, Erik Jones wrote: On Mar 17, 2009, at 4:47 AM, Craig Ringer wrote: The question is: Which DBMS do you think is the best for this kind of application? PostgreSQL or MySQL? As you can imagine, PostgreSQL. My main reasons are that in a proper transactional environment (i

Re: [GENERAL] Uploading data to postgresql database

No specific reason for using the old version. Still in the process of upgrading the softwares that we are using in the project. Soon, we'll be using the latest version. Does using an old version stop me from using a particular functionality? Subha Scott Marlowe wrote: On Tue, Mar 17, 2009 at

Re: [GENERAL] Uploading data to postgresql database

On Wed, Mar 18, 2009 at 1:31 AM, Subha Ramakrishnan wrote: > No specific reason for using the old version. > Still in the process of upgrading the softwares that we are using in the > project. > Soon, we'll be using the latest version. > > Does using an old version stop me from using a particular

Re: [GENERAL] postmaster never finishes starting up, silent to boot

On Tue, Mar 17, 2009 at 11:27 PM, Scott Marlowe wrote: > Hard to say with what you've told us so far. what more should I post/need? I was suspecting that as well as I've never had postgres be silent and not work -- I've also never let a db fill its disk and get f'ed like this. should I just let t

Re: [GENERAL] Uploading data to postgresql database

ogr2ogr can write most formats to most other formats. It can certainly write to a PostGIS database, & read KML., so if it can write it to shape, it can write direct to Postgis You just need to set your output format to postgis. Note: depending on where you got GDAL (ogr2ogr) from, it may or may

Re: [GENERAL] postmaster never finishes starting up, silent to boot

On Wed, Mar 18, 2009 at 2:18 AM, Aaron Glenn wrote: > On Tue, Mar 17, 2009 at 11:27 PM, Scott Marlowe > wrote: >> Hard to say with what you've told us so far. > > what more should I post/need? I was suspecting that as well as I've Remember that mentiion of vmstat and top I made in my last post?

Re: [GENERAL] Uploading data to postgresql database

That would be great. I do have GDAL compiled with postgis. I'll definitely try this option. Thanks a lot. Subha Brent Wood wrote: ogr2ogr can write most formats to most other formats. It can certainly write to a PostGIS database, & read KML., so if it can write it to shape, it can write direc

Re: [GENERAL] PostgreSql with or without Plus?

Simon Riggs wrote: On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote: Postgres Plus does support Linux and it includes all the PostgreSQL features as well as have many other additional useful features.One of which is its dyna tune module. You can check through the webpage http://ww

[GENERAL] schema, view and role

I've this view: create or replace view catalog_promosimple_v as select p.PromoSimpleID, p.IsPromo, p.Percent, p.OnListPrice, p.Vendible, p.OnStock, p.Dist, p.PromoStart, p.PromoEnd, pi.ItemID, pi.Discount from catalog_promosimple p join catalog_promosimpleitem pi on pi.PromoSimpleID=

Re: [GENERAL] Is PGSQL enough safe for internet?

durumdara wrote: > > Can I define in PGSQL, which DataBases can read from the localhost, and > which can from the net? Yes. See "authentication" in the manuals for details on pg_hba.conf and also "grant connect". Only allow password-protected connection over an encrypted ssl channel. Only allow c

Re: [GENERAL] PostgreSql with or without Plus?

On Wed, 2009-03-18 at 14:36 +0530, Ashish Karalkar wrote: > Simon Riggs wrote: > > On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote: > >> Postgres Plus does support Linux and it includes all the PostgreSQL > >> features as well as have many other additional useful features.One of > >>

[GENERAL] Query 4-5 times slower after ANALYZE

Hi, I'm using Postgresql 8.3.6 under Freebsd 7.1. After a fresh restore of a customer dump (running version 8.2.7 at the moment), a rather big query executes in about 30 seconds. As soon as I run ANALYZE, it is instantly 4-5 times slower. I could check that multiples times. Here is the EXPLAIN A

Re: [GENERAL] Is PGSQL enough safe for internet?

On Wed, 18 Mar 2009 09:32:56 +0100 durumdara wrote: > Possible he can install an another pgsql service that can be > opened to the net and that can usable for ONLY THIS PROJECT. But I > don't know, that is possible or not; and how to upgrade later, if > needed... :-( If you can't use another DB.

Re: [GENERAL] PostgreSql with or without Plus?

On Wed, Mar 18, 2009 at 9:53 AM, Simon Riggs wrote: > > Exactly my point: it is not a value-add for Postgres Plus, which was the > only value-add you mentioned. Those features either work with standard > Postgres distro, or they are not available unless you use the non-free, > non-open distro. So

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

John Cheng wrote: >> This is question for Juan, have you asked the MySQL mailing list? Not yet. Admitting my ignorance in databases, I'm trying to understand all the concepts discussed in this thread . Be sure today I will ask the MySQL list. Thanks 2009/3/17 John Cheng > This is question f

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

Merlin Moncure writes: > A good rule of thumb for large is table size > working ram. Huge > (really large) is 10x ram. Or better yet, large is data > working ram. Very large is data > directly attached drives... That means that without fairly expensive hardware you start talking about "very lar

Re: [GENERAL] Query 4-5 times slower after ANALYZE

In response to "Philippe Lang" : > > I'm using Postgresql 8.3.6 under Freebsd 7.1. > > After a fresh restore of a customer dump (running version 8.2.7 at the > moment), a rather big query executes in about 30 seconds. As soon as I > run ANALYZE, it is instantly 4-5 times slower. I could check tha

Re: [GENERAL] postgreSQL & amazon ec2 cloud

Thanks Stuart I will try Ubuntu image at Amazon cloud. Seems..they are looking for testers too. Not much of tester, but will be able to at least post to list if something fails ;-) Will try centos after that. With best regards. Sanjay Arora. On Tue, Mar 17, 2009 at 12:10 PM, Stuart Bishop wrote:

Re: [GENERAL] Query 4-5 times slower after ANALYZE

Bill Moran writes: > I opened one of those links figuring I'd take a few minutes to see if I could > muster up some advice ... and just started laughing ... definitely not the > type of query that one can even understand in just a few minutes! You might consider setting default_statistics_target

Re: [GENERAL] Query 4-5 times slower after ANALYZE

> In response to "Philippe Lang" : >> >> I'm using Postgresql 8.3.6 under Freebsd 7.1. >> >> After a fresh restore of a customer dump (running version 8.2.7 at the >> moment), a rather big query executes in about 30 seconds. As soon as I >> run ANALYZE, it is instantly 4-5 times slower. I could che

[GENERAL] Report all Comments

Hi all, i need make a report of all comments in the all tables. Where postgres storage it? Thanks Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com

[GENERAL] sql transaction

Hi, Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql function(user defined) which is written in PL/Perl? Thanks in advance -- With warm regards Jasid Z. A +91 9946109809

Re: [GENERAL] Report all Comments

paulo matadr wrote: Hi all, i need make a report of all comments in the all tables. Where postgres storage it? Thanks Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10

Re: [GENERAL] sql transaction

Jasid ZA wrote: > Hi, > > Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql > function(user defined) which is written in PL/Perl? No. A function is an autonomous transaction. You can use savepoints. Andreas -- Really, I'm not out to destroy Microsoft. That will just be

Re: [GENERAL] Query 4-5 times slower after ANALYZE

Oh, the other thing you could try experimenting with are these two parameters. Your query has *way* more tables than the default values for these so you would have to raise them substantially. Given that the query was running in 30s you may find that this increases the planning time by more time

Re: [GENERAL] Query 4-5 times slower after ANALYZE

hi it's look better with explain.depesz.com :) you can easily find that in "before" it uses index scan and in "after" it uses seq before: http://explain.depesz.com/s/RC after: http://explain.depesz.com/s/nm try as mentioned before to change costs Best regards, Sebastian Pawłowski Wia

Re: [GENERAL] sql transaction

Andreas Kretschmer wrote: > Jasid ZA wrote: > > > Hi, > > > > Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql > > function(user defined) which is written in PL/Perl? > > No. A function is an autonomous transaction. You can use savepoints. This question comes up very of

Re: [GENERAL] sql transaction

Alvaro Herrera wrote: > Andreas Kretschmer wrote: > > Jasid ZA wrote: > > > > > Hi, > > > > > > Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql > > > function(user defined) which is written in PL/Perl? > > > > No. A function is an autonomous transaction. You can use s

Re: [GENERAL] sql transaction

Andreas Kretschmer wrote: > Alvaro Herrera wrote: > > > Andreas Kretschmer wrote: > > > Jasid ZA wrote: > > > > > > > Hi, > > > > > > > > Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql > > > > function(user defined) which is written in PL/Perl? > > > > > > No. A func

Re: [GENERAL] postmaster never finishes starting up, silent to boot

On Wed, Mar 18, 2009 at 01:18:46AM -0700, Aaron Glenn wrote: > On Tue, Mar 17, 2009 at 11:27 PM, Scott Marlowe > wrote: > start run it's course? for a 35GB+ database how long should I wait? is > there no way to log the status of what the postgres daemon is actually > doing while I wait? what's th

Re: [GENERAL] PostgreSql with or without Plus?

On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote: > Postgres Plus does support Linux and it includes all the PostgreSQL > features as well as have many other additional useful features.One of > which is its dyna tune module. Yes it does, but it doesn't use native packages (as far as I

Re: [GENERAL] Query 4-5 times slower after ANALYZE

pgsql-general-ow...@postgresql.org wrote: > In response to "Philippe Lang" : >> >> I'm using Postgresql 8.3.6 under Freebsd 7.1. >> >> After a fresh restore of a customer dump (running version 8.2.7 at >> the moment), a rather big query executes in about 30 seconds. As >> soon as I run ANALYZE, i

Re: [GENERAL] sql transaction

Alvaro Herrera wrote: Andreas Kretschmer wrote: Alvaro Herrera wrote: Andreas Kretschmer wrote: Jasid ZA wrote: Hi, Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql function(user defined) which is written in PL/Perl? No. A function is an autonomous transaction. Y

Re: [GENERAL] sql transaction

Tino Wildenhain wrote: > But this sounds like fun, I'll check how to add something to the > documentation :-) Of course it is fun. Why else do you think I spend time on it? -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Cust

Re: [GENERAL] Query 4-5 times slower after ANALYZE

In response to "Philippe Lang" : [snip] > > Anyway, the real reason I posted -- I doubt if anyone will be able to > > make sense of a query plan that complex without the actual query, so > > you'll probably want to post it as well. > > :) What? I thought you would read that like Neo was readin

[GENERAL] The service name is invalid net helpmsg 2185

Hi Don't know if this is the correct forum for this, if not please point me in the correct direction but have installed 8.3.6.1 in a windows 2003 64 bit server, in the default directories for the program files, data on a seperate drive, set up postgres as a local user with admin rights, but when

[GENERAL] max_fsm_relations and max_fsm_pages problem

Hi: I have max_fsm_relations set to 1200 and max_fsm_pages set to 20 in postgres.conf (well over 16x max_fsm_relations) but still get... FATAL: max_fsm_pages must exceed nax_fsm_relations * 16 What's up ? (v8.3 on Linux)

Re: [GENERAL] max_fsm_relations and max_fsm_pages problem

Nevermind (wrong postgres.conf, in wrong dir) Sorry. -dave From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave Sent: Wednesday, March 18, 2009 11:13 AM To: pgsql-general@postgresql.org Subject: [GENERAL

Re: [GENERAL] max_fsm_relations and max_fsm_pages problem

Question How many database objects or relations do you have? Thanks Deepak On Wed, Mar 18, 2009 at 8:12 AM, Gauthier, Dave wrote: > Hi: > > > > I have max_fsm_relations set to 1200 and max_fsm_pages set to 20 in > postgres.conf (well over 16x max_fsm_relations) but still get... > > > > FATAL

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

juankarlos.open...@gmail.com (Juan Pereira) writes: > Quite interesting! The main reason why we thought using a table per > truck was because concurrent load: if there are 100 trucks trying to > write in the same table, maybe the performance is worse than having > 100 tables, due to the fact that t

Re: [GENERAL] sql transaction

On Wed, Mar 18, 2009 at 7:11 PM, Andreas Kretschmer < akretsch...@spamfence.net> wrote: > Jasid ZA wrote: > > > Hi, > > > > Can we use sql transactions(BEGIN, ROllBACK, COMMIT etc) in a postgresql > > function(user defined) which is written in PL/Perl? > > No. A function is an autonomous transact

[GENERAL] DBD::Pg's $dbh->func( "/path/to/file", 'lo_import' ) fails silently

I'm trying to use Perl's DBD::Pg module to import a file as a large object. For this I'm using the following: my $oid = $dbh->func( "/absolute/path/to/file", 'lo_import' ); When I do this, a new record is added to pg_largeobject, with a proper-looking non-null loid, but the data field remains emp

Re: [GENERAL] schema, view and role

On Wed, Mar 18, 2009 at 2:40 PM, Ivan Sergio Borgonovo wrote: > If the view is just an alias for the SQL as "text" and it is not > interpreted at creation time... This assumption is wrong. A view is "compiled" at creation time, and the compiled version of the view is used in queries. -- gurje

Re: [GENERAL] Maximum transaction rate

Marco Colombo wrote: > Ron Mayer wrote: >> Greg Smith wrote: >>> There are some known limitations to Linux fsync that I remain somewhat >>> concerned about, independantly of LVM, like "ext3 fsync() only does a >>> journal commit when the inode has changed" (see >>> http://kerneltrap.org/mailarchive

[GENERAL] Accent insensitive search?

Hi, I have a DB in utf-8 and postgres 8.3.x. How can I do an accent insensitive search (like ...) ? TIA

Re: [GENERAL] Accent insensitive search?

Hi, use ILIKE HTH, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Wednesday 18 March 2009 04:29:24 pm cifroes wrote: > Hi, > > I have a DB in utf-8 and postgres 8.3.x. > > How can I do an accent insensitive search (like ...) ? > > > TIA signature.asc Description: This is a digital

Re: [GENERAL] Accent insensitive search?

Not case insensitive but accent insensitive :) And I tried select to_ascii('capo','LATIN1'), to_ascii('çapo','LATIN1') and the results are different -Original Message- From: pgsql-general-ow...@postgresql.org on behalf of Pedro Doria Meunier Sent: Wed 3/18/2009 4:46 PM To: pgsql-gen

Re: [GENERAL] Accent insensitive search?

2009/3/18 Pedro Doria Meunier > Hi, > > use ILIKE > > HTH, > ILIKE is only case-insensitive, and won't match accented characters. The only thing I can think of doing is to create a function which will replace characters with their equivalent non-accented counterparts and use that in the query.

Re: [GENERAL] Accent insensitive search?

Here's an example of a function I might use (although I haven't actually got plperl installed, so can't test it myself, but you'll get the idea: CREATE OR REPLACE FUNCTION unaccent_string(text) RETURNS text AS $$ my ($input_string) = @_; $input_string =~ s/[âãäåāăą]/a; $input_string =~ s/[ÁÂÃÄÅĀĂĄ

Re: [GENERAL] Accent insensitive search?

On Wed, Mar 18, 2009 at 04:29:24PM -, cifroes wrote: > I have a DB in utf-8 and postgres 8.3.x. > > How can I do an accent insensitive search (like ...) ? No good idea at the moment; I'd somehow expect to find this sort of normalization in the functionality provided by the "text search" code

Re: [GENERAL] Accent insensitive search?

Ooops! Silly me! I should have read more carefully ... (blush) sorry! Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Wednesday 18 March 2009 04:46:16 pm Pedro Doria Meunier wrote: > Hi, > > use ILIKE > > HTH, > > Pedro Doria Meunier > GSM: +351961720188 > Skype: pdoriam > > On Wednesday

Re: [GENERAL] Accent insensitive search?

2009/3/18 Sam Mason > > If you can't find anything better in PG; the translate[1] function would > be my best suggestion. Performance should be better than using regular > expressions. > > Yeah, that does appear to perform better. I tried the following at it worked for me: CREATE OR REPLACE FU

Re: [GENERAL] Accent insensitive search?

Sam Mason wrote on 18.03.2009 18:15: On Wed, Mar 18, 2009 at 04:29:24PM -, cifroes wrote: I have a DB in utf-8 and postgres 8.3.x. How can I do an accent insensitive search (like ...) ? No good idea at the moment; I'd somehow expect to find this sort of normalization in the functionality

Re: [GENERAL] Accent insensitive search?

how about... select where translate(lower(myfield), 'âãäåāăąèééêëēĕėęěìíîïìĩīĭóôõöōŏőùúûüũūŭů', 'aaaeeooouuu') = 'stringiwannamatch'; or something like that. I may have miscounted the vowells in the 'to' string :) - Sent via pgsql-general mailing l

Re: [GENERAL] Accent insensitive search?

What I've done in the past in this situation is to create a separate field with the text normalized to whatever the search form is (all lower case, accents stripped, etc.), and then index and search that from the application. Although I've not tried it, a functional index that did the same

Re: [GENERAL] DBD::Pg's $dbh->func( "/path/to/file", 'lo_import' ) fails silently

I would suggest you join the Perl DBI mailing list and ask your question there. There are some quite capable people in that group who could help you troubleshoot this issue. It's called dbi-us...@perl.org. Look at http://lists.cpan.org/showlist.cgi?name=dbi-users, where it tells you how to su

[GENERAL] configure question

If this questions belongs on a different listserv, please let me know. I've got a question regarding ./configure. In v. 8.013 (okay, I'm running old stuff) we had the following options: --with-java --with-multibyte --with-unicode In attempting to upgrade to 8.3.7, those flags are ignored. Tha

Re: [GENERAL] Accent insensitive search?

On Wed, 18 Mar 2009, cifroes wrote: Hi, I have a DB in utf-8 and postgres 8.3.x. How can I do an accent insensitive search (like ...) ? Take a look on text search capability and http://www.sai.msu.su/~megera/wiki/unaccent We have patches for CVS HEAD, but unfortunately they will likely go

Re: [GENERAL] Accent insensitive search?

Thom Brown escribió: > Here's an example of a function I might use (although I haven't actually got > plperl installed, so can't test it myself, but you'll get the idea: > > CREATE OR REPLACE FUNCTION unaccent_string(text) RETURNS text AS $$ > my ($input_string) = @_; > $input_string =~ s/[âãäåāăą

Re: [GENERAL] Accent insensitive search?

On Mar 18, 2009, at 11:24 AM, Alvaro Herrera wrote: Hmm, if to_ascii() doesn't work, that's something worth some research. Maybe the encoding config is broken, for example. The docs say to_ascii() only works with LATIN1, LATIN2, LATIN9, and WIN1250; maybe convert('string', 'UTF-8', 'SQL_ASCI

Re: [GENERAL] configure question

On Wednesday 18 March 2009 19:50:17 Jeffrey Trimble wrote: > I've got a question regarding ./configure. > > In v. 8.013 (okay, I'm running old stuff) we had the following options: > > --with-java > --with-multibyte > --with-unicode > > In attempting to upgrade to 8.3.7, those flags are ignored. Th

Re: [GENERAL] DBD::Pg`s $dbh->func( "/path/to/file", `lo_import` ) fails silently

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > I'm trying to use Perl's DBD::Pg module to import a file as a large object. > For this I'm using the following: > my $oid = $dbh->func( "/absolute/path/to/file", 'lo_import' ); Works fine for me. What version of DBD::Pg are you using? Try som

Re: [GENERAL] Query 4-5 times slower after ANALYZE

"Philippe Lang" writes: > A small question here: solde_po is an SQL function (not PLPGSQL). Is it > "inlined" in the parent query before the whole query execution plan is > calculated? You should be able to tell that by inspecting the filter conditions in the ANALYZE output. Do you see solde_po(

[GENERAL] How to configure PostgreSQl for low-profile users

Dear Sirs, I would like to rent a my application to a number of customer, each with a dedicated database (and perhaps a dedicated username). The database will be installed on 'public IP' machine and will be accessed by internet on standard port 5432 and using ODBC driver from several clients (whi

Re: [GENERAL] How to configure PostgreSQl for low-profile users

On Wed, Mar 18, 2009 at 09:15:31PM +0100, dfx wrote: > It is possible to configure the security policy so that the simple users > (the customer, in this case) can only read, write, update end delete data to > the dedicated database AND NOTHING ELSE, particularly: I assume you're implying a caveat

Re: [GENERAL] How to configure PostgreSQl for low-profile users

In response to "dfx" : > Dear Sirs, > > I would like to rent a my application to a number of customer, each with a > dedicated database (and perhaps a dedicated username). > > The database will be installed on 'public IP' machine and will be accessed > by internet on standard port 5432 and using

Re: [GENERAL] Maximum transaction rate

Greg Smith wrote: > On Wed, 18 Mar 2009, Marco Colombo wrote: > >> If you fsync() after each write you want ordered, there can't be any >> "subsequent I/O" (unless there are many different processes >> cuncurrently writing to the file w/o synchronization). > > Inside PostgreSQL, each of the datab

[GENERAL] Installation Error, Server Won't Start

I downloaded the 8.3 exe for Windows (XP) and started the installation. When it got near the end, a warning window opened stating "Problem running post-install step. Installation may not complete correctly. Failed to start the database server." When I openned the pgadmin, the server pane showed

[GENERAL] ORDER BY: lexicographic ordering of names

All, I am porting a database from MS SQL Server to Postgres. One of the tables contains a list of names, which I would like to list alphabetically. I noticed in the "O" names the following difference: MSSQL: O'Daniel O'Neill Oliveira Oliver While PGSQL sorts as if the apostrophe w

Re: [GENERAL] Installation Error, Server Won't Start

On 18/03/2009 21:10, ray wrote: > I downloaded the 8.3 exe for Windows (XP) and started the > installation. When it got near the end, a warning window opened > stating "Problem running post-install step. Installation may not > complete correctly. Failed to start the database server." Did you se

Re: [GENERAL] Maximum transaction rate

On Wed, Mar 18, 2009 at 10:58:39PM +0100, Marco Colombo wrote: > I hope it's "full defence". If you have two processes doing at the > same time write(); fsycn(); on the same file, either there are no order > requirements, or it will boom sooner or later... fsync() works inside > a single process, b

Re: [GENERAL] Maximum transaction rate

Ron Mayer wrote: > Marco Colombo wrote: >> Ron Mayer wrote: >>> Greg Smith wrote: There are some known limitations to Linux fsync that I remain somewhat concerned about, independantly of LVM, like "ext3 fsync() only does a journal commit when the inode has changed" (see http://k

Re: [GENERAL] Maximum transaction rate

On Wed, 18 Mar 2009, Martijn van Oosterhout wrote: Generally PG uses O_SYNC on open Only if you change wal_sync_method=open_sync. That's the very last option PostgreSQL will try--only if none of the other are available will it use that. Last time I checked the defaults value for that para

Re: [GENERAL] Installation Error, Server Won't Start

On Mar 18, 5:07 pm, r...@iol.ie ("Raymond O'Donnell") wrote: > On 18/03/2009 21:10, ray wrote: > > > I downloaded the 8.3 exe for Windows (XP) and started the > > installation.  When it got near the end, a warning window opened > > stating "Problem running post-install step.  Installation may not >

Re: [GENERAL] Maximum transaction rate

Martijn van Oosterhout wrote: > Generally PG uses O_SYNC on open, so it's only one system call, not > two. And the file it's writing to is generally preallocated (not > always though). It has to wait for I/O completion on write(), then, it has to go to sleep. If two different processes do a write(

Re: [GENERAL] ORDER BY: lexicographic ordering of names

Bryan Herger wrote: > I am porting a database from MS SQL Server to Postgres. One of the > tables contains a list of names, which I would like to list > alphabetically. I noticed in the "O" names the following difference: Note to whoever answers: this is a frequent question, so consider adding

Re: [GENERAL] ORDER BY: lexicographic ordering of names

Alvaro Herrera writes: > Bryan Herger wrote: >> I am porting a database from MS SQL Server to Postgres. One of the >> tables contains a list of names, which I would like to list >> alphabetically. I noticed in the "O" names the following difference: > Note to whoever answers: this is a frequent

Re: [GENERAL] ORDER BY: lexicographic ordering of names

Il 18-03-2009 21:32, Bryan Herger ha scritto: All, I am porting a database from MS SQL Server to Postgres. One of the tables contains a list of names, which I would like to list alphabetically. I noticed in the “O” names the following difference: MSSQL: O’Daniel O’Neill Oliveira Oliver While P