Re: [GENERAL] Need help for constructing query

x(date),min,value,max from mytable group by id,min,value,max; Gives too many rows. I don't know why. If I can manage to fix the query above just to output one row per id I can solve it. Marco -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

[GENERAL] Need help for constructing query

from mytable group by id; gives just the id and the date, not the other values. I think of doing this in two steps: 1) Display the rows with the highest date per id. That gives as many rows as ids exist. 2) Remove the rows that do not match ( valuemin ) Marco -- Sent via pgsql-general mailing

[GENERAL] Query with time zone offset but without seconds

1-03-25 18:01 If I do select date_trunc( 'minute', datetime) from table; then the time zone offset is present, but the seconds are not removed: 2011-03-25 18:01:00+01 I want it to look like this: 2011-03-25 18:01+01 How to do that? Marco -- Sent via pgsql-general mailing

Re: [GENERAL] Need help for constructing query

WHERE datetime BETWEEN CURRENT_TIMESTAMP - INTERVAL '10 minutes' AND CURRENT_TIMESTAMP ) AS t WHERE t.datetime=t.last AND ( value>=min AND value<= max ) ); Marco -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] Query with time zone offset but without seconds

On 2011-03-25 scrawf...@pinpointresearch.com (Steve Crawford) wrote: > On 03/25/2011 10:05 AM, Marco wrote: > > I have a column »timestamp with time zone«. I want to extract the > > date/time in a different format including the time zone offset in a query > > but wit

Re: [GENERAL] Need help for constructing query

On 2011-03-27 rsmog...@softperience.eu (Radosław Smogura) wrote: > Marco Friday 25 March 2011 14:25:47 > > Hi, > > > > I have a table like this: > > > > id datemin max value > > 1 2011-03-25 20 30 17 > > 3 20

[GENERAL] is possible to read oracle tables from PostgresSQL

I need to know if is possible to read oracle tables from PostgresSQL (and vice versa). Can someone give me some help? Thanks a lot ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Ubuntu and Rails postgresql setup

I am on a Ubuntu 14.04 LTS machine. I found useful information on how to configure PostgreSQL in Ubuntu for Rails development at help.ubuntu.com , at Heroku and at digitalocean.com <

Re: [GENERAL] Ubuntu and Rails postgresql setup

Would the LTS version be also adequate for development? I am configuring my Ubuntu machine for development purposes. According to the PostgreSQL download page, "Ubuntu "snapshots" a specific version of PostgreSQL that is then supported throughout the lifetime of that Ubuntu version".

Re: [GENERAL] Ubuntu and Rails postgresql setup

Once support for 14.04 LTS will be terminated in 2019, there will not be any more support for PostgreSQL too. At that time I suppose I and other Ubuntu users will be left with the only choice to install from scratch another version of Ubuntu and related software, included PostgreSQL.

[GENERAL] Error: no connection to the server

Hi, I have a multithreaded C client and sometimes I receive the "no connection to the server" error message. I haven't found any documentation about it and about how to fix this issue. Anyone can point me to the right direction? How can I fix it? Thanks a lot. -- Marco Bambin

Re: [GENERAL] PITR Base Backup on an idle 8.1 server

Greg Smith wrote: [...] -Find something harmless I can execute in a loop that will generate WAL activity, run that until the segment gets archived. Haven't really thought of something good to use for that purpose yet. Some time ago I started a thread about taking on-the-fly backups at file l

Re: [GENERAL] PITR Base Backup on an idle 8.1 server

Greg Smith wrote: On Thu, 31 May 2007, Marco Colombo wrote: archive_command = 'test ! -f /var/lib/pgsql/backup_lock Under normal condition (no backup running) this will trick PG into thinking that segments get archived. If I'm not mistaken, PG should behave exactly as if no archi

Re: [GENERAL] PITR Base Backup on an idle 8.1 server

Greg Smith wrote: The way you're grabbing files directly from the xlog directory only works because your commit workload is so trivial that you can get away with it, and because you haven't then tried to apply future archive logs. Well, it's only because I don't need future logs, just like I

Re: [GENERAL] PITR Base Backup on an idle 8.1 server

Simon Riggs wrote: > Marco Colombo wrote: my method ...is dangerous Ok, but why? Once again, I'm asking: what _exactly_ can go wrong? > so we don't get loads of new DBAs picking up this idea but missing the exact point of danger. I'm one of them. I'm _am_ missing

Re: [GENERAL] PITR Base Backup on an idle 8.1 server

Greg Smith wrote: On Tue, 5 Jun 2007, Marco Colombo wrote: AFAIK, files in pg_xlog are first renamed (and only if and after the archive_command returned true) and later overwritten to. Never deleted. No, they get deleted sometimes, too. Not often, but it can happen under heavy load if more

Re: [GENERAL] PITR Base Backup on an idle 8.1 server

Simon Riggs wrote: On Tue, 2007-06-05 at 18:39 +0200, Marco Colombo wrote: I'm asking: what _exactly_ can go wrong? If a checkpoint occurs while taking the backup then the contents of the files will be overwritten ^ Data files or WAL segments? My archive command prevents WAL seg

Re: [GENERAL] PostGreSQL for a small Desktop Application

Gabriele wrote: I'm going to develop a medium sized business desktop client server application which will be deployed mostly on small sized networks and later eventually, hopefully, on medium sized networks. It will probably be developed using C#. I do need a solid DBMS wich can work with .Net f

Re: [GENERAL] unexpected shutdown

[EMAIL PROTECTED] wrote: [EMAIL PROTECTED] writes: My database has shutdown several times in the last couple days. I have no idea why. I am running centos and I have not rebooted the server or made any configuration changes. Oh, I forgot. You do have plenty of swap space compared to RAM, yes

Re: [GENERAL] unexpected shutdown

ter. If you do, it's a hard call. If you think about it, the funny thing is that the more experienced the sysadm you're talking to is, the less experience he has about handling OOM situations. By definition. :) .TM. -- / / / / /

Re: [GENERAL] Delete/update with limit

Csaba Nagy wrote: > First of all, thanks for all the suggestions. > >> put a SERIAL primary key on the table > Or: >> Maybe add OIDs to the table, and delete based on the OID number? > > No, this is not acceptable, it adds overhead to the insertions. Normally > the overhead will be small enough,

[GENERAL] computing and updating the size of a table with large objects

r, but uses just one file descriptor for all the query. Does anyone has any other suggestion? Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

Re: [GENERAL] computing and updating the size of a table with large objects

- > Daniel > PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org > Thanks a lot for the suggestion: I didn't think to use the pg_largeobject: much cleaner, now :-) Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end

Re: [GENERAL] Cannot declare record members NOT NULL

Cultural Sublimation wrote: >> Unfortunately for you, they are not different types. If the OCaml >> binding thinks they are, it's the binding's problem; especially since >> the binding seems to be using a completely lame method of trying to tell >> the difference. > > Hi, > > In OCaml and in oth

[GENERAL] understanding pgstatindex

Hey all. When running pgstatindex(some_index) I'm getting the usual result: Version, tree_level, index_size, root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation with a bunch of numbers. Now, my question are What each one represent (

[GENERAL] Understanding pgstatindex

Hey all. When running pgstatindex(some_index) I'm getting the usual result: Version, tree_level, index_size, root_block_no, internal_pages, leaf_pages, empty_pages, deleted_pages, avg_leaf_density, leaf_fragmentation with a bunch of numbers. Now, my question are What each one represent (

Re: [GENERAL] [ADMIN] backup of postgres scheduled with cron

backups manually. The script > itself is executed fine if run manually but run on cron scheduler I got an > mydb_dump_$time.out file empty (of 0 kb) > > Do you have any idea about what's wrong? > > Thanks > Sorin > Hi Sorin, why don't you add a &q

Re: [GENERAL] [ADMIN] backup of postgres scheduled with cron

On Nov 22, 2007 2:46 PM, Sorin N. Ciolofan <[EMAIL PROTECTED]> wrote: > Hi Marco! > > Thank you for the advice. > > I got: > > /home/swkm/services/test/backup.sh: line 4: pg_dump: command not found > updating: mydb_dump_22-11-07.out (stored 0%) > > which see

Re: [GENERAL] [ADMIN] backup of postgres scheduled with cron

On Nov 22, 2007 2:53 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote: > On Thu, Nov 22, 2007 at 02:28:08PM +0100, Marco Bizzarri wrote: > > > > why don't you add a "MAILTO=" at the start of your > > crontab file, so that you can receive a report of the probl

Re: [GENERAL] Restart a sequence regularly

; getting an error. If you remove the privs, clients will get an error, unless I'm missing something. .TM. -- / / / / / / Marco Colombo ___/ ___ / / Technical Manager / / /

Re: [GENERAL] Why LIMIT and OFFSET are commutative

Andrus wrote: >> Under what interpretation would the results differ? > > Results must differ for easy creation of LinQ-PostgreSQL driver. > If results are always the same , PostgreSQL should not allow to use both > order of clauses. > > Nicholas explains: > >Assuming the ordering is the same

[GENERAL] Import LDAP data to a Postgres database

Hi, my question is this: it is possible to query, using SQL, an LDAP server and put these data to a table of a Postgres database (under linux) ??? Thanks to all. _ Scarica GRATIS 30 emoticon per Messenger! http://www.emoticons-livem

[GENERAL] query

Hello I need to be able distribute like my application with postgresql to the final client and since as I can assure or encryptar the database to avoid the command trust. Thank you __ ¿Chef por primera vez? Sé un mejor Cocinillas. http:/

Re: [GENERAL] Linux

On 11/04/2010 04:00 PM, Michael Gould wrote: I know that this is probably a "religion" issue but we are looking to move Postgres to a Linux server. We currently have a Windows 2008 R2 active directory and all of the other servers are virtualized via VMWare ESXi. One of the reasons is that we want

Re: [GENERAL] Linux x Windows LOCALE/ENCODING compatibility

On 11/09/2010 02:31 AM, Carlos Henrique Reimer wrote: Hi, I'm currently in the process of moving the data from the Windows server to the new Linux box but facing some problems with the encoding. Additional configuration information: Windows is running PG 8.3 and the new Linux box is PG 8.4. Wi

Re: [GENERAL] Pl/Python error when import "from __future__"

On 03/31/2011 09:58 PM, Davi Duarte wrote: Hello, I'm using PL/Python in PostegreSQL 9.0.3 and Python 2.6.5, I want to use a feature of Python 3, Python have an option to import a module from future version of Python. In my case, I want to use the Python 3 division module, because it returns a

Re: [GENERAL] pg_restore

On 03/31/2011 01:08 AM, Mike Orr wrote: That might be a better solution. I was hoping to use the same pgdump file for this that I also use for routine offline backup, but maybe this is such a special case that a separate dump file would be better. Why don't you post the exact mysqldump/mysql co

[GENERAL] Howto implement sxntax and semantic complie time chock for

queries? Message-ID: <[EMAIL PROTECTED]> Reply-To: Froa: Marc Weber <[EMAIL PROTECTED]> Hi, I'd like to implement some query checking at compile time for haskell using template haskell. Is there any query method such as explain input and output types of query "SELECT (1,'string')" or "INSERT IN

Re: [GENERAL] Temporary Tables and Web Application

they have been written > to disk/read from disk? You could create a real table on disk, inserting just the primary keys of the table; then, you could join on the main table, to get the real results. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- Sent via pgsql-general m

[GENERAL] NAS

Hello there! A customer of our company would like to create a 2 nodes cluster connected to an external NAS storage. I would like to know if PostgreSQL supports its datafiles on this kind of storage and if this solution is certified. Thanks Marco Fortina Senior Consultant Mobile:+39 348

[GENERAL] getting domain information from query results

x27;d have to implement all of the associated operators and functions for my new type as well (they'd just be cut 'n pastes of the equivalent operators for varchar, but that's still a bit more work than i'd like to do at this point). thanks for the help, -- -marco -- Sent via

[GENERAL] getting domain information from query results

ent all of the associated operators for my new type as well (they'd just be cut 'n pastes of the equivalent operators for varchar, but that's still a bit more work than i'd like to do at this point). thanks for the help, -- -marco -- 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] Preventing OOM kills

On 05/25/2011 03:01 AM, John R Pierce wrote: On 05/24/11 5:50 PM, Andrej wrote: Add more RAM? Look at tunables for other processes on the machine? At the end of the day making the kernel shoot anything out of despair shouldn't be the done thing. somehow, 'real' unix has neither a OOMkiller nor

Re: [GENERAL] Postgres error when adding new page

t;E:/mingw/msys/1.0/home/ctest/build/Continuous/dogen/mingw-1.0.17-i686-gcc-4.7/build/stage/bin/dogen_utility_spec" "--run_test=xml/closing_an_open_text_reader_does_not_throw"','Completed','UnVubmluZyAxIHRlc3QgY2FzZS4uLgoKKioqIE5vIGVycm9ycyBkZXRlY3RlZAo=') These are repeated several ti

Re: [GENERAL] Postgres error when adding new page

y i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5666) (dot 3), 64-bit We'll look into upgrading to 9.1.6. Cheers Marco -- So young, and already so unknown -- Pauli blog: http://mcraveiro.blogspot.com

Re: [GENERAL] Postgres error when adding new page

t as far as OSX is concerned. We then upgraded, but to save us time we moved directly to 9.2.1. This is not ideal in terms of root-causing the underlying problem but as we can't afford the time to do multiple upgrades, we had to go for it. CDash is now very happy - no errors on the log. Many t

Re: [GENERAL] solaris slow

On 02/08/2010 21:14, John R Pierce wrote: Another factor, if your linux system was using LVM (its the default storage configuration on many distributions), there's a pretty good chance the drive mapper is ignoring write barriers, which greatly speeds up random writes at the expense of reliable co

Re: [GENERAL] MySQL versus Postgres

On 11/08/2010 04:01, Greg Smith wrote: 3. The default configuration settings for PostgreSQL are not optimal for performance. Can there be a recommended configuration file in the installation (assuming certain amount of RAM and processor type) ? This doesn't work because there are many different

Re: [GENERAL] MySQL versus Postgres

On 11/08/2010 17:34, Greg Smith wrote: The problem here is that the amount of shared memory a system can allocate is hard to discover any other way than starting the server and seeing if it works. So doing what you advise will leave the database unable to start on any system that hasn't gotten th

Re: [GENERAL] MySQL versus Postgres

On 12/08/2010 03:43, Tom Lane wrote: Marco Colombo writes: It's a matter of correctness: I see PG as a high performance database system. Allowing to start it in awfully suboptimal conditions it's no different from allowing '-00-00' as a date: it may give you the id

[GENERAL] Advice on implementing counters in postgreSQL

one of them has to be restarted and redone from scratch. Is there a way to avoid this behaviour? maybe with lock to tables? Thanks you all for your attention Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) T

Re: [GENERAL] Advice on implementing counters in postgreSQL

Thanks for the advice, Craig. I'm on a number of different PostgreSQL versions, ranging from 7.4 to 8.3, so I've to retain, where possible, compatibility with older versions. Is this better on a transaction/serialization point of view? Regards Marco On Sat, Aug 2, 2008 at 10:19

Re: [GENERAL] Advice on implementing counters in postgreSQL

On Sat, Aug 2, 2008 at 11:04 AM, Craig Ringer <[EMAIL PROTECTED]> wrote: > Marco Bizzarri wrote: >> Thanks for the advice, Craig. >> >> I'm on a number of different PostgreSQL versions, ranging from 7.4 to >> 8.3, so I've to retain, where possible, com

Re: [GENERAL] Advice on implementing counters in postgreSQL

On Sat, Aug 2, 2008 at 5:11 PM, David Fetter <[EMAIL PROTECTED]> wrote: > On Sat, Aug 02, 2008 at 09:23:31AM +0200, Marco Bizzarri wrote: >> Hi all. >> >> I need to keep a numer of counters in my application; my counters >> are currently stored in a table: >>

Re: [GENERAL] Advice on implementing counters in postgreSQL

y code. Up to now, I wrote considering a serializable level, so I think I should do quite a review to be sure about it. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- 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] Postgresql RPM upgrade (8.2.3 -> 8.2.9)

ssed. If that does not solve the problem, post the error message. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- 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] Dumping/Restoring with constraints?

Phoenix Kiula wrote: Thanks Andrew. On the server (the DB to be dumped) everything is "UTF8". On my home server (where I would like to mirror the DB), this is the output: =# \l List of databases Name| Owner | Encoding ---+-+--- pos

Re: [GENERAL] warning: libssl.so.4, needed by

On Fri, Aug 29, 2008 at 2:39 PM, J Welcomecert <[EMAIL PROTECTED]> wrote: It looks like you haven't openssl installed on your system, or you didn't provided the right switches for compiling it? Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ http://iliveinp

Re: [GENERAL] Frustrated...pg_dump/restore

Jeff Amiel wrote: > Ahhh > *looks at encoding* > > Well..they are both the same...BUT...they are set to > ENCODING = 'SQL_ASCII'; > > That explains a lotthey should probably be set to Unicode UTF8 > Duh > > Any way to change encoding without dumping/restoring database? You can

Re: [GENERAL] Starting PostgreSQL

admin wrote: > Sorry folks, a perennial one I'm sure ... > > I have read the manual and Googled for a couple of hours but still can't > connect to PostgreSQL 8.3.4 (the PGDG RPMs running on an up to date > CentOS 5.2). > > I continually get this message: > > psql: could not connect to server: No

Re: [GENERAL] NATURAL JOINs

Scott Marlowe wrote: > On Wed, Oct 15, 2008 at 10:17 AM, Richard Broersma > <[EMAIL PROTECTED]> wrote: >> On Wed, Oct 15, 2008 at 9:03 AM, Reg Me Please <[EMAIL PROTECTED]> wrote: >> >>> Both are perfectly right, indeed. >>> Nonetheless, in my opinion a NATURAL JOIN exploiting the FKs >>> instead

Re: [GENERAL] Enc: Help to replace caracter

;); END LOOP; END; $BODY$ LANGUAGE 'plpgsql'; I run this query to change the text " by * : SELECT replace_char( '"' , '*' ); should read the documentation: http://www.postgresql.org/docs/current/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP Saludos y abrazos... Marco Antonio Frias Butrón [EMAIL PROTECTED] Slackware ~ Linux User #356229 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] No tables in postgres and template db

ion of potgresql and the installation worked fine on both the operative system. I can access to postgres server and create my db and my tables. However i've noticed that postgres,template0 and template1 contain no tables. I've checked that by console and pgadmin. (By linux console) ma...@m

Re: [GENERAL] Good Delimiter for copy command

Tom Lane wrote: > Andrew Gould writes: >> To the list: Does pg_dump escape characters that are the same as the >> delimiter? > > Yes. The OP has not actually explained why he needs to pick a > nondefault delimiter, unless maybe it is that he wants to feed the > dump to some program that is too

Re: [GENERAL] php4 and postgresql 8.3

Tom Lane wrote: > shadrack writes: >> My basic question is...are php4 and postgresql 8.3 compatible? >> I'm running Linux Redhat 3.4.6, php4.3.9, and postgresql 8.3. I know, >> some of those versions are old...its government, and I unfortunately >> don't have control over the version. > > Er ...

Re: [GENERAL] Maximum transaction rate

Scott Marlowe wrote: > On Fri, Mar 6, 2009 at 2:22 PM, Ben Chobot wrote: >> On Fri, 6 Mar 2009, Greg Smith wrote: >> >>> On Fri, 6 Mar 2009, Tom Lane wrote: >>> Otherwise you need to reconfigure your drive to not cache writes. I forget the incantation for that but it's in the PG list a

Re: [GENERAL] Maximum transaction rate

Tom Lane wrote: > Marco Colombo writes: >> And I'm still wondering. The problem with LVM, AFAIK, is missing support >> for write barriers. Once you disable the write-back cache on the disk, >> you no longer need write barriers. So I'm missing something, what els

Re: [GENERAL] Maximum transaction rate

Scott Marlowe wrote: > On Fri, Mar 13, 2009 at 1:09 PM, Christophe wrote: >> So, if the software calls fsync, but fsync doesn't actually push the data to >> the controller, you are still at risk... right? > > Ding! > I've been doing some googling, now I'm not sure that not supporting barriers i

Re: [GENERAL] Maximum transaction rate

Joshua D. Drake wrote: > On Sat, 2009-03-14 at 05:25 +0100, Marco Colombo wrote: >> Scott Marlowe wrote: > >> Also see: >> http://lkml.org/lkml/2008/2/26/41 >> but it seems to me that all this discussion is under the assuption that >> disks have write-ba

Re: [GENERAL] Maximum transaction rate

Joshua D. Drake wrote: > > I understand but disabling cache is not an option for anyone I know. So > I need to know the other :) > > Joshua D. Drake > Come on, how many people/organizations do you know who really need 30+ MB/s sustained write throughtput in the disk subsystem but can't afford a

Re: [GENERAL] Maximum transaction rate

John R Pierce wrote: > Stefan Kaltenbrunner wrote: >> So in my understanding LVM is safe on disks that have write cache >> disabled or "behave" as one (like a controller with a battery backed >> cache). > > what about drive write caches on battery backed raid controllers? do > the controllers ens

Re: [GENERAL] Maximum transaction rate

Greg Smith wrote: > On Tue, 17 Mar 2009, Marco Colombo wrote: > >> If LVM/dm is lying about fsync(), all this is moot. There's no point >> talking about disk caches. > > I decided to run some tests to see what's going on there, and it looks > like some o

Re: [GENERAL] Maximum transaction rate

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/linux-kernel/2008/2/26/9905

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 synchronizatio

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 >>>>

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] Maximum transaction rate

Martijn van Oosterhout wrote: > True, but the relative wakeup order of two different processes is not > important since by definition they are working on different > transactions. As long as the WAL writes for a single transaction (in a > single process) are not reordered you're fine. I'm not tota

Re: [GENERAL] Maximum transaction rate

Ron Mayer wrote: > Marco Colombo wrote: >> Yes, but we knew it already, didn't we? It's always been like >> that, with IDE disks and write-back cache enabled, fsync just >> waits for the disk reporting completion and disks lie about > > I've looked ha

Re: [GENERAL] Maximum transaction rate

Markus Wanner wrote: > Hi, > > Martijn van Oosterhout wrote: >> And fsync better do what you're asking >> (how fast is just a performance issue, just as long as it's done). > > Where are we on this issue? I've read all of this thread and the one on > the lvm-linux mailing list as well, but still

Re: [GENERAL] Storing HTML: HTML entities being rendered in that raw form

linnewbie wrote: > On Apr 9, 1:00 pm, st...@blighty.com (Steve Atkins) wrote: >> On Apr 9, 2009, at 9:27 AM, linnewbie wrote: >> >>> Hi all, >>> I have stored HTML in a text field that I subsequently render on the >>> web. However when I retrieve and render this data on the web I am >>> getting t

[GENERAL] Postgres partially hang after inactivity

ays closed cleanly or closed at all. Postgres version is 8.3.7. Regards, Marco. -- 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] Postgres partially hang after inactivity

unclosed sessions hanging around. Thank you for your help. Regards, Marco. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Query

postgresql no reconoce el campo_virtual. ¿Es que postgresql no soporta esta consulta o existe algun otro metodo para lograr esta tecnica? Nota: (campo1 - campo2) en realidad es una compleja consulta que se usa varias veces lineas abajo. Marco.- -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] PostgreSQL scaleability question

advantage of commercial software is psychological: it's much easier to convince your boss pay 50,000$ in hardware if your company is already paying similar figures in software. That is, companies are more willing to pay $100,000 50% hardware and 50% software than $50,000 100% hardware, to solve

Re: [GENERAL] Scalability with large numbers of tables

too old. Please note that as far as PostgreSQL is concerned, CPU usage is more important than raw speed in tests, IMHO. And I bet both the filesystems have improved since then. Now I wonder, is tab-completion faster in Oracle? B-) .TM. -- / / / / /

Re: [GENERAL] Clay Shirky observation regarding MySQL

den of making technologies available to as many non-guru users as possible is on distribution makers. If Mr. Shirky wants to set a date, and say "before that" and "after that", it's the day open source distrubutions hit the masses. Ce

Re: [GENERAL] pgadmin3 / postgresql newbie question

e same connection method you're using with pgadmin3, and run it under the same user you run pgadmin3 with. E.g.: psql -h localhost -p 5432 -U postgres mydb see psql manual for details. If you successfully get to 5), it's likely it's a pgadmin3 problem. .TM. -- _

Re: [GENERAL] [Auth] "ident" method and LDAP user accounts

is not on /etc/passwd, only in LDAP. So, we still have a mystery :-( Does Debian include and activate SELinux? .TM. -- / / / / / / Marco Colombo ___/ ___ / / Technical Manager / / /

Re: [GENERAL] postgresql vs mysql performance comparison

ient library, or buy a commercial licence from them. Why? With PostgreSQL you don't have to thing about these issues. A big win. .TM. -- ____/ / / / / / Marco Colombo ___/ ___ / / Technic

Re: [GENERAL] plpython function problem workaround

#1, May 7 2004, 10:31:40) [GCC 3.3.3 20040412 (Red Hat Linux 3.3.3-7)] running: print 1 print 2 1 2 end running: print 1^M print 2^M File "", line 1 print 1^M ^ SyntaxError: invalid syntax end Finalized. I bet on windows the first program fails and the second is ok

Re: [GENERAL] plpython function problem workaround

at the end of a line that I can think of). But requiring the input being text is not 'bizarre' at all. The issue about text representation affects _any_ application. Treating text as binary data is plain wrong, IMHO, and will always lead to problems. .TM. -- __

Re: [GENERAL] plpython function problem workaround

ess the recommended way to document a function (or class or module or whatever). See PEP 257 for more examples: http://www.python.org/peps/pep-0257.html So, to answer to your question, newlines are more than allowed in string literals. .TM. -- / / / / / /

Re: [GENERAL] plpython function problem workaround

ussing until we have some real world data. I can't compile on windows, so I'll have to wait someone else to do that. I'm basing my opinions on Python documentation only. .TM. -- / / / / / / Marco Colombo ___/ ___ / /

Re: [GENERAL] New user: Windows, Postgresql, Python

On Wed, 16 Mar 2005, Michael Fuhr wrote: On Wed, Mar 16, 2005 at 01:46:23PM +0100, Marco Colombo wrote: It seems python documentation is plain wrong, or I'm not able to read it at all: http://docs.python.org/ref/physical.html "A physical line ends in whatever the current platform'

Re: [GENERAL] New user: Windows, Postgresql, Python

On Wed, 16 Mar 2005, Michael Fuhr wrote: On Wed, Mar 16, 2005 at 04:17:51PM +0100, Marco Colombo wrote: aprogram = "x = 1\nprint x\n"; printf(aprogram); PyRun_SimpleString(aprogram); See? THIS program requires compile-time or run-time checks. You can't run it on

Re: [GENERAL] plpython function problem workaround

On Wed, 16 Mar 2005, Michael Fuhr wrote: [I've changed the Subject back to the thread that started this discussion.] On Wed, Mar 16, 2005 at 05:52:02PM +0100, Marco Colombo wrote: I'm against to any on-the-fly conversion, now. I don't like the idea of PostgreSQL accepting input in

Re: [GENERAL] pg_dump large-file support > 16GB

filesystem. .TM. -- / / / / / / Marco Colombo ___/ ___ / / Technical Manager / / / ESI s.r.l. _/ _/ _/ [EMAIL PROTECTED] ---(

Re: [GENERAL] plpython function problem workaround

On Thu, 17 Mar 2005, Tom Lane wrote: Martijn van Oosterhout writes: On Thu, Mar 17, 2005 at 01:03:36PM +0100, Marco Colombo wrote: OMG! It's indenting the funtion body. I think you can't do that w/o being syntax-aware. I'm not familiar with the code, why is it adding a 'def&#x

Re: [GENERAL] plpython function problem workaround

seems those rules are not the same. Marco, you've stated that you're against munging the code because "it's not our job to 'fix' data coming from the client." But I'm suggesting that we think about the code in a different way than the current implementation d

Re: [GENERAL] plpython function problem workaround

ld you apply it only to HEAD, or would it be considered a bug fix that REL8_0_STABLE could get as well? It might be nice to have it in 8.0.2, whenever that comes out. I think it would be reasonable to back-patch a small fix to convert CRLF. The sort of rewrite Marco is considering, I wouldn't

  1   2   3   >