Re: [GENERAL] postgre vs MySQL

On Tue, Mar 11, 2008 at 3:31 PM, Dann Corbit <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:pgsql-general- > > [EMAIL PROTECTED] On Behalf Of rrahul > > Sent: Tuesday, March 11, 2008 6:48 AM > > To: pgsql-general@postgresql.org > > Subject: [GENER

Re: [GENERAL] Problems with 8.3

Ah... no I didn't know that - that would explain all the other behaviour then!! Good to know. Alex On Sat, Mar 8, 2008 at 3:03 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Alex Turner" <[EMAIL PROTECTED]> writes: > > ... I found what was going on in tha

Re: [GENERAL] Problems with 8.3

On Sat, Mar 8, 2008 at 1:05 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote: > On 3/8/08, Alex Turner <[EMAIL PROTECTED]> wrote: > > > No I'm not. Where would a core file be if there was going to be one? > > They should appear in the data directory (e.g. /v

Re: [GENERAL] Problems with 8.3

nd also in ~/.bash_profile for postgres Alex On Sat, Mar 8, 2008 at 11:01 AM, Douglas McNaught <[EMAIL PROTECTED]> wrote: > On 3/8/08, Alex Turner <[EMAIL PROTECTED]> wrote: > > Well - I know that my stored proc is segfaulting based on a strace of > > postgresql. Don't kn

Re: [GENERAL] Problems with 8.3

Mar 7, 2008 at 11:42 PM, Alex Turner <[EMAIL PROTECTED]> wrote: > Well - I think it might be that some of my servlets weren't closing > their database connections properly. > > I do have some new evidence though: > > I did an strace of the tomcat processes, and I not

Re: [GENERAL] Problems with 8.3

he other wierd thing is that this process also throws a SIGSEGV at another point. I wasn't expecting tomcat to crash, so alas I didn't capture a core file. I guess I should set the system default up. Alex On Fri, Mar 7, 2008 at 2:28 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: &g

Re: [GENERAL] Problems with 8.3

I didn't. And after the reboot, I still see 8 new sockets stuck in CLOSE_WAIT - I'm wondering if this is a hardware/kernel problem... Alex On Fri, Mar 7, 2008 at 11:50 AM, Alex Turner <[EMAIL PROTECTED]> wrote: > Nothin worth mentioning in /var/log/messages > > Th

Re: [GENERAL] Problems with 8.3

]> wrote: > Alex Turner wrote: > > It was core dumping on the 5th of March, but it hasn't since. It's > > just failing with the connection closed problem. It seems to happen > > worst with queries that are going to do updates and with connections > > that are

Re: [GENERAL] Problems with 8.3

#x27;t made any difference :( Alex On Fri, Mar 7, 2008 at 3:00 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: > Alex Turner wrote: > > I had stored procs in C on 8.2 for months, and I moved them over to > > 8.3 when we upgraded. > > And re-compiled them, yes? >

Re: [GENERAL] Problems with 8.3

I did a pg_ctl start from the postgres user... is that gonna work, or does pg_ctl do an su? Alex On Thu, Mar 6, 2008 at 4:34 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > "Alex Turner" <[EMAIL PROTECTED]> writes: > > I'm thinking I need a core file. > >

Re: [GENERAL] Problems with 8.3

=trend host=localhost port=51586 but when it fails, I get nothing in the log at all... ALex On Thu, Mar 6, 2008 at 4:09 PM, Alex Turner <[EMAIL PROTECTED]> wrote: > Sometimes I'm getting LOG: unexptected EOF on client connection > > Alex > > > > On Thu, Mar 6, 2008

Re: [GENERAL] Problems with 8.3

Sometimes I'm getting LOG: unexptected EOF on client connection Alex On Thu, Mar 6, 2008 at 4:06 PM, Alex Turner <[EMAIL PROTECTED]> wrote: > Ok - the connection closed thing is happening a lot, but not much is > going into pg_log... > > Alex > > > > On T

Re: [GENERAL] Problems with 8.3

Ok - the connection closed thing is happening a lot, but not much is going into pg_log... Alex On Thu, Mar 6, 2008 at 4:03 PM, Douglas McNaught <[EMAIL PROTECTED]> wrote: > On 3/6/08, Alex Turner <[EMAIL PROTECTED]> wrote: > > Ok - lookint at the pg log, it appears that

Re: [GENERAL] Problems with 8.3

hem. I'm thinking I need a core file. I'm guessing I just restart postgresql from a user whos core file size limit is set to non zero? Alex On Thu, Mar 6, 2008 at 3:49 PM, Alex Turner <[EMAIL PROTECTED]> wrote: > I'm getting the back end closing connections early for some

[GENERAL] Problems with 8.3

I'm getting the back end closing connections early for some reason. Here is an exception report from my servlet. This first started happening with my instance of Trac, but now it's happening to my Java apps too. I hope someone can shed some light on what is going on here. Alex HTTP Status 500

Re: [GENERAL] Postgres 8.3 broke everything

21 Feb 2008 19:49:29 -0500 > > "Alex Turner" <[EMAIL PROTECTED]> wrote: > > > > Yeah - I pressed tab to indent my code, and of course it tabbed to the > > next element on the page, which was the send button, then I hit a key, > > and it sent the mess

Re: [GENERAL] Postgres 8.3 broke everything

PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > > On Thu, 21 Feb 2008 17:53:35 -0500 > "Alex Turner" <[EMAIL PROTECTED]> wrote: > > > Upgrading to Postgres 8.3 broke virtually every site we host, and I > > finall

[GENERAL] Postgres 8.3 broke everything

Upgrading to Postgres 8.3 broke virtually every site we host, and I finally figured out why. In 8.2 you could do this: create table foo ( ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] [OT] "advanced" database design (long)

#x27;m a fan of keeping products as DB neutral as possible)? Alex On Feb 4, 2008 7:09 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Feb 3, 2008 10:14 PM, Alex Turner <[EMAIL PROTECTED]> wrote: > > I"m not a database expert, but wouldn't > > > > create tab

Re: [GENERAL] [OT] "advanced" database design (long)

That is a very awesome system. I am constantly impressed at the awesomeness of Postgresql. Alex On Feb 4, 2008 1:06 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Jorge Godoy <[EMAIL PROTECTED]> writes: > > Em Monday 04 February 2008 07:03:47 Dawid Kuroczko escreveu: > >> Well, but PostgreSQL's NULLs

Re: [GENERAL] [OT] "advanced" database design (long)

AIL PROTECTED]> wrote: > On Feb 3, 2008 10:14 PM, Alex Turner <[EMAIL PROTECTED]> wrote: > > I"m not a database expert, but wouldn't > > > > create table attribute ( > > attribute_id int > > attribute text > > ) > > > > crea

Re: [GENERAL] [OT] "advanced" database design (long)

I"m not a database expert, but wouldn't create table attribute ( attribute_id int attribute text ) create table value ( value_id int value text ) create table attribute_value ( entity_id int attribute_id int value_id int ) give you a lot less pages to load than building a table w

Re: [GENERAL] PostgreSQL/PHP Application Server

Frameworks are over-rated. PHP makes most common tasks simple (not that I'm really a big PHP fan, but it works pretty well most of the time). Just follow a few basic XSS protection rules, and you will have few problems. Filter input elements for HTML, don't put stupid things in cookies that can

Re: [GENERAL] Sun acquires MySQL

I love Postgresql to death, it's one of the shining stars of the Open Source movement IMHO. It's rock solid, crashes less frequently than Oracle in my experience, and does almost everything I could ask of it (granted - I don't ask much often, just simple things like consistent behaviour, which see

Re: [GENERAL] advocacy: drupal and PostgreSQL

I evaluated Drupal with PostgreSQL, but it wasn't powerful enough, and it's written in PHP which is buggy, and lots of modules force you to use MySQL which is not ACID (I'm sorry but inserting 31-Feb-2008 and not throwing an error by default makes you non-ACID in my book). PostgreSQL support was s

Re: [GENERAL] query performance

Oh - if you do this then make sure that you have the primary key index on overview too. Alex On Jan 14, 2008 12:53 AM, Alex Turner <[EMAIL PROTECTED]> wrote: > If you combine it with Tom Lane's suggestion - it will go even better, > something like: > > select * from t_do

Re: [GENERAL] query performance

) > Index Cond: ((t_documentcontent._id)::text = ("outer"._id)::text) > Total runtime: 106.323 ms > > I now need to see what trigers i need to add, and test the insertions. > Thanks again > > > On Jan 14, 2008 5:54 AM, Alex Turner <[EMAIL PROTECTED]> wrot

Re: [GENERAL] query performance

e update happens between someone viewing a page and hitting next to view the next page. Alex On Jan 13, 2008 11:43 PM, Alex Turner <[EMAIL PROTECTED]> wrote: > If you have to access the data this way (with no where clause at all - > which sometimes you do) then I have already provi

Re: [GENERAL] query performance

If you have to access the data this way (with no where clause at all - which sometimes you do) then I have already provided a solution that will work reasonably well. If you create what is essentially a materialized view of just the id field, the sequence scan will return much fewer pages than whe

Re: [GENERAL] query performance

If you haven't already, make sure you've done a vacuum full recently. When in doubt, pg_dump the db, and reload it, and see if that helps, but this works for me: create table overview as select _id from t_documentcontent; alter table overview add constraint overview_pkey primary key (_id); selec

Re: [GENERAL] Disk arrangement in a cheap server

Why the hell would you buy a 1U chassis in the first place when perfectly good cheap 4U chassis exists that will take 8 or more drives? 1U motherboards are a pain, 1U power supplies are a pain and 1U space for drives sucks. Most tests I've seen these days show that there is very little actual ben

[GENERAL] Errors trying to install compat-postgresql-libs:

I get the following error installing the binary RPMS for RedHat es 4: [EMAIL PROTECTED] postgres]# rpm -Uvh compat-postgresql-libs-4-1PGDG.i386.rpm error: Failed dependencies: libc.so.6(GLIBC_2.4) is needed by compat-postgresql-libs-4-1PGDG.i386 libcrypto.so.6 is needed by compat-po

Re: [GENERAL] Problem with pg_dump

panicked when the thought occurred to me that I didn't have a good backup ;)Alex.On 11/10/06, Andreas Kretschmer <[EMAIL PROTECTED]> wrote: Alex Turner <[EMAIL PROTECTED]> schrieb:> Sure thing, I hope it's as simple as user error!>> #!/bin/sh> export DATE=`date +%Y

Re: [GENERAL] Problem with pg_dump

I would be happy to point someone to the dump file, it's about 500Meg thoughAlexOn 11/10/06, Alex Turner < [EMAIL PROTECTED]> wrote:Sure thing, I hope it's as simple as user error! #!/bin/shexport DATE=`date +%Y%m%d`/usr/local/pgsql/bin/pg_dump -Upostgres -hlocalhost trend >

Re: [GENERAL] Problem with pg_dump

, but it didn'tAlexOn 11/10/06, Joshua D. Drake <[EMAIL PROTECTED] > wrote:On Fri, 2006-11-10 at 11:23 -0500, Tom Lane wrote:> "Alex Turner" < [EMAIL PROTECTED]> writes:> > Well yes - thats what I mean, the definition for the index.  It's not> > dumping the index

Re: [GENERAL] Problem with pg_dump

m 09.11.2006, um 13:04:31 -0500 mailte Alex Turner folgendes:>>> I seem to be having a problem with pg_dump in 8.1.2, it's not dumping indexes>> at all.  Is this a known problem, should I just do an upgrade? >>>> I can't see a necessity to dump a index. But, i

[GENERAL] Problem with pg_dump

I seem to be having a problem with pg_dump in 8.1.2, it's not dumping indexes at all.  Is this a known problem, should I just do an upgrade?Thanks,Alex TurnerMint Pixels

Re: [GENERAL] Size of tuples

Awesome - thank you!AlexOn 10/9/06, Ron Johnson <[EMAIL PROTECTED]> wrote: -BEGIN PGP SIGNED MESSAGE-Hash: SHA1On 10/09/06 19:10, Alex Turner wrote:> I have a table whose definition is basically>> create table foo (> a int,> b int,> c int, > d date> );>&

[GENERAL] Size of tuples

I have a table whose definition is basicallycreate table foo (a int,b int,c int,d date);and when fully populated, select relpages*8192::long/reltuples from pg_class where relname='foo'; gives around 52.  Why is it so wide when there are only 4*4=16 bytes of actual data?The table was populated in on

[GENERAL] Is relpages always supposed to be right?

Is relpages always supposed to be right?:select count(*) from result_entry;trend=# select count(*) from result_entry; count--- 59913(1 row)trend=# select relpages from pg_class where relname='result_entry';  relpages--    0(1 row)trend=#Alex

Re: [GENERAL] Notes on converting from MySQL 5.0.x to PostgreSQL

http://dev.mysql.com/doc/refman/5.1/en/replication-row-based.html5.1AlexOn 7/10/06, Jan Wieck <[EMAIL PROTECTED]> wrote: On 6/30/2006 11:12 AM, Scott Marlowe wrote:> I agree with Tom, nice notes.  I noted a few minor issues that seem to> derive from a familiarity with MySQL.  I'll put my correctio

Re: [GENERAL] RAID + PostgreSQL?

Please note that your single Fibre Channel card is limiting you to 256MB/sec read speed from your array, which is not enough for a 13 drive RAID 5.First test would be to run a basic bonnie++ benchmark against your drive array and see what kind of throughput you are getting for linear read, linear w

Re: [GENERAL] RAID + PostgreSQL?

Of course if you really want good performance, 6 drives is a little light, and U320 is definatley not the way to go as you are limited to 320MB/sec per channel (an the DL380 comes with all drives on one channel) (not that you could saturate that with only 6 drives in RAID 10 anyway).  Given that th

Re: [GENERAL] RAID + PostgreSQL?

Compaq RAID controllers are known to be slow under linux.Alex.On 6/26/06, Tony Caduto <[EMAIL PROTECTED] > wrote:Scott Marlowe wrote:> On Mon, 2006-06-26 at 08:59, Tony Caduto wrote: >>> MG wrote:> Hello,>> we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6.>> When we do a

Re: [GENERAL] Database Clustering on multiple harddisk

On 6/20/06, arie nugraha <[EMAIL PROTECTED]> wrote: Thanks a Alex,But can tou give a bit explanation about multiple separate tablespaceThis will give you the basic syntax for the commands. http://www.postgresql.org/docs/8.1/static/sql-createtablespace.htmlhttp://www.postgresql.org/docs/8.1/static/s

Re: [GENERAL] Database Clustering on multiple harddisk

I think you may be a little confused...Last time I checked, Oracle RAC doesn't actualy support clustering the I/O, it's one Database backend with multiple instances on the front-end, which is only clustering the CPU bound part (it's also VERY expensive). If by clustering you mean multiple seperate

Re: [GENERAL] Ever increasing OIDs - gonna run out soon?

Just a quick thought - I know that I don't fully understand tables with oids, and table without oids, is there a link to some more information about why you need oids, or why you don't that I could reference as I'm a bit lost on the subject of oids Alex.On 6/12/06, Tom Lane <[EMAIL PROTECTED]> wrot

Re: [GENERAL] Problems with database bloat

I suspect that my manualy vacuum every 10 days or so really wasn't nearly enough ;)AlexOn 6/9/06, Jim C. Nasby < [EMAIL PROTECTED]> wrote:This tells me that you need to be vacuuming more. Autovac is your friend.On Thu, Jun 08, 2006 at 07:14:01PM -0400, Alex Turner wrote:> Yeah

Re: [GENERAL] Problems with database bloat

Yeah - I just did a reindex, that fixed the indexes at least.AlexOn 6/8/06, Jim C. Nasby <[EMAIL PROTECTED] > wrote:On Thu, Jun 08, 2006 at 06:03:23PM -0400, Alex Turner wrote:> I hope I'm reading this query wrong: >> trend=# select relname, relpages*8192/reltuples from pg_clas

[GENERAL] Problems with database bloat

I hope I'm reading this query wrong:trend=# select relname, relpages*8192/reltuples from pg_class where reltuples>0 order by relpages desc limit 10;    relname    | ?column?---+--  property  | 19935.4468376195 resul

Re: [GENERAL] Is it a big deal to change the user the DB runs under?

could you just add the postgres user to the apache group?AlexOn 6/5/06, Tony Caduto <[EMAIL PROTECTED] > wrote:Just wondering if anyone has done this:Change the user the DB runs under from postgres to apache on a established server?I would think I would just change ownership on all the data dir fil

Re: [GENERAL] SCSI disk: still the way to go?

Maximum througput of a single drive is around 80MB/second, a 300MB/sec interface won't change that.AlexOn 6/1/06, Riccardo Inverni < [EMAIL PROTECTED]> wrote:Hi Alex,   thanks for the answer (thanks to the other guys too!). http://www.cdw.com/shop/products/default.aspx?EDC=912784 SATA - ~$320 Is

Re: [GENERAL] SCSI disk: still the way to go?

Compare these two drives:http://www.storagereview.com/php/benchmark/suite_v4.php?typeID=10&testbedID=4&osID=6&raidconfigID=1&numDrives=1&devID_0=279&devID_1=308&devCnt=2 Prices:http://www.cdw.com/shop/products/default.aspx?EDC=984588 - SAS - ~$950 http://www.cdw.com/shop/products/default.aspx?EDC=9

Re: [GENERAL] SCSI disk: still the way to go?

SAS and SATA will give you the best throughput for your array total.  U320 is limited to 320MB/channel.AlexOn 5/30/06, Scott Marlowe < [EMAIL PROTECTED]> wrote:On Tue, 2006-05-30 at 16:28, Riccardo Inverni wrote: > Hi guys,>>I have to update a Linux box with PostgreSQL on it, essentially for> d

Re: [GENERAL] Hardware related question: 3ware 9500S

A... good point.Why oh why does tyan have two boards with the same prefix ;)!!!AlexOn 4/15/06, Guy Rouillier < [EMAIL PROTECTED]> wrote:Alex Turner wrote:> Raid 5 on the 9550SX is supposed to be significantly better than the > 9500 series.>> I would be carefull of benchmarks listed out there.  

Re: [GENERAL] Hardware related question: 3ware 9500S

I have the time to do it, but not the $$s ;)AlexOn 4/15/06, Francisco Reyes <[EMAIL PROTECTED] > wrote:Alex Turner writes:> Suggests that the 9550SX is at least competitive with the others. Thanks for the links.> I know I like the 3ware/AMCC cards because of their very good RAID 10> performance.Rai

Re: [GENERAL] Hardware related question: 3ware 9500S

Raid 5 on the 9550SX is supposed to be significantly better than the 9500 series.I would be carefull of benchmarks listed out there.  For instance, whilst looking for supporting material, I came cross this gem: http://www.gamepc.com/labs/print_content.asp?id=9550sx4lp&cookie%5Ftest=1 They claim th

Re: [GENERAL] database design questions

create table person (id serial8,name text);AlexOn 4/3/06, Alban Hertroys <[EMAIL PROTECTED] > wrote:Ottavio Campana wrote:>>   CREATE TABLE person (>>   id   SERIAL, >>   name TEXT>>   );> how can I do it with a INT8 instead of a INT4?Do you really expect that sequence to reach over 2 billi

Re: [Bulk] [GENERAL] General advice on database/web applications

The solution that I have seen typical is to have both webserver and database machine behind a firewall both NATed, with only HTTP and HTTPS ports open on the webserver.  SSH is not open, as trusted clients connect via the VPN in the firewall.  The database machine, unlike the webserver, will not ha

Re: [GENERAL] Postgres Wierdness

ory. > > > > When the server comes back up, it claims: > > LOG: database system was not propertly shut down; automatic recovery in > > progress > > > > I'm using the Jdbc3PoolingDataSource to connection. The code isn't > > doing any write transactions at

[GENERAL] Postgres Wierdness

code isn't doing any write transactions at all at this point. Anyone any idea what might be happening here? Alex Turner ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] RAID 5 and postgresql

I would suppliment this with just saying that your controller card is your performance, the only cards I've seen score well on linux, and people have expressed on this list for SCSI are the LSI card, for SATA, LSI, 3ware (now AMCC) and Areca claim good linux support and seem to work well. Steer ful

Re: [GENERAL] Changing ids conflicting with serial values?

I think he meant create sequence test_seq; select setval('test_seq',(select max(primary_key_id) from my_table)); not max value of a serial type. Alex On 11/3/05, Marc Boucher <[EMAIL PROTECTED]> wrote: > On Wed, 02 Nov 2005 19:29:10 -0800, you wrote: > > >It's a migration thing - MySQL prevente

Re: [GENERAL] SQL injection

? I hate FUD. Alex On 11/3/05, Hannes Dorbath <[EMAIL PROTECTED]> wrote: > On 03.11.2005 04:12, Alex Turner wrote: > > I would have to say that for security purposes - I would want magic > > quotes _on_ rather than off for the whole reasons of SQL Injection > > that we

Re: [GENERAL] SQL injection

Curiously none are security reasons, they are more portability reasons (and pretty thin ones at that)... but then this is PHP we are talking about - let me just say register_globals and end it there. I would have to say that for security purposes - I would want magic quotes _on_ rather than off fo

Re: [GENERAL] SQL injection

My point is that with magic_quotes on in PHP, php already escapes quotes for you in all inbound variables. This makes the process automatic, and therefore fool proof, which is kinda the whole point. You want a mechanism that there isn't an easy way around, like forgetting to db_quote once in a wh

Re: [GENERAL] SQL injection

I didn't think query plans were cached between sessions, in which case prepeared statements aren't worth much for most HTTP based systems (not counting luckily re-using the same connection using pgpool)... Please correct me if I'm mistaken - I like being wrong ;) Alex On 10/31/05, Jim C. Nasby <

Re: [GENERAL] SQL injection

Can you demonstrate a URL/attack that would constitute an injection attack that would get around magic-quotes, or provide some links to such? Alex On 10/31/05, MaXX <[EMAIL PROTECTED]> wrote: > Hi, > > Yonatan Ben-Nes wrote: > > Hi all, > > > > I'm currently trying to build a defence against SQL

Re: [GENERAL] SQL injection

I don't know too much about this solutions, but It always seemed to me that simple numeric validation plus magic-quotes will work just fine. Simply validate any numeric input (or you can just quote it with postgresql, and postgres will do it for you), and auto-escape any string inputs (particularl

Re: [GENERAL] Oracle 10g Express - any danger for Postgres?

I assume they are probably thinking of a free for non-commercial use, which is great and all, but I assume that like the majority of folks here, I am using postgres very much for commercial use, and not just to run my personal website! So I would say it's not a big deal, infact it's not even a sma

Re: [GENERAL] Why database is corrupted after re-booting

I have read it before - it's a _fantastic_ resource, and I will probably make every junior tech I ever hire read it too. On 10/28/05, Bruce Momjian wrote: > Alex Turner wrote: > > Of course not counting the Western Digital Raptor SATA drive, which > > are priced more like S

Re: [GENERAL] Why database is corrupted after re-booting

Of course not counting the Western Digital Raptor SATA drive, which are priced more like SCSI drives also, and have many of the features of a SCSI drive including NCQ Alex On 10/28/05, Bruce Momjian wrote: > Andrus wrote: > > >> QUANTUM FIREPALLP LM20.5 is a widely used ATA IDE drive. > > >> > >

Re: [GENERAL] Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1

I believe based on semi-recent posts that MIN and MAX are now treated as special cases in 8.1, and are synonymous with select id order by id desc limit 1 etc.. Alex On 10/24/05, Douglas McNaught <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] writes: > > > However, in the process of investigating

Re: [GENERAL] PostgreSQL vs mySQL, any performance difference for large queries?

I would ask you to ask the reverse question, why would you use MySQL when it still doesn't contain all the features of postgresql, has a bad query optimizer, a poor track record on scalability and will silenty truncate/accept invalid data, invalidating ACID, not only that you have to pay for it. W

Re: [GENERAL] a stored procedure ..with integer as the parameter

On 24 Oct 2005 22:00:55 +0200, Harald Fuchs <[EMAIL PROTECTED]> wrote: In article <[EMAIL PROTECTED]>,Alex Turner <[EMAIL PROTECTED] > writes:> 1.  ( ) text/plain  (*) text/html> As sort of a side discussion - I have postulated that quoting all incomming> nu

Re: [GENERAL] pg_dump, MVCC and consistency

Beleive me, when you get data feeds with bad data and you have to do each insert as an xact because copy will just dump out, you can hit 1bil really fast. AlexOn 10/24/05, Martijn van Oosterhout wrote: On Mon, Oct 24, 2005 at 11:25:00AM -0600, Michael Fuhr wrote:> PostgreSQL 8.

Re: [GENERAL] a stored procedure ..with integer as the parameter

As sort of a side discussion - I have postulated that quoting all incomming numbers as string would be an effective defense against SQL Injection style attacks, as magic quotes would destory any end-quote type syntax: in_value=1 select * from table where my_id='$in_value'; as an example for PHP

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

ay on this one?  I googled it a bit, but didn't come up with much. Alex Turner NetEconomist On 10/20/05, Marc G. Fournier <[EMAIL PROTECTED]> wrote: On Thu, 20 Oct 2005, Doug Quale wrote:> "Guy Rouillier" <[EMAIL PROTECTED]> writes:>>> Doug Quale wrote:>&

Re: [GENERAL] On "multi-master"

  >multi-master.  It provides a certain amount of scaling, but nothing>I've seen or heard suggests that the license cost couldn't just as >easily and effectively be thrown at larger hardware for better>scaling.  The really big reason to use RAC is five-nines situations:>you're trying to make sure t

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

you have to setup oracle insuch a way as to disable any database to database access / joining.Seems to me the second you can run a query that hits both databases you might well be in breach of contract, depending on the terminology used.On Thu, 2005-10-13 at 14:44, Alex Turner wrote:> Of course, b

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

n this case, PostgreSQL's schemas and Oracle'sseparate databases are functionally identical, nomenclature aside. On Thu, 2005-10-13 at 13:58, Alex Turner wrote:> I could, but it would breach the terms of our contract.  Our contract> with the data providers clearly specifies seperate

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

that idea ;). AlexOn 10/13/05, Tino Wildenhain <[EMAIL PROTECTED]> wrote: Am Donnerstag, den 13.10.2005, 13:00 -0400 schrieb Alex Turner:...>>>> If I had just one wish for postgresql it would be to support> cross-database queries like Oracle.  This is a HUGE pain in the ass, >

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

I have to keep data that is related in seperate databases, and my clients _want_ me to cross join it for select purposes, but I'm legaly required to keep it in a seperate database. Maybe it's just difference shock - Postgresql<>Oracle so I'm scared ;), but I don't like dblink very much ;) Alex Turner NetEconomist

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

resql databases so that they can actualy _scale_ when a business grows. AlexOn 10/13/05, Chris Travers <[EMAIL PROTECTED]> wrote: Alex Turner wrote:> Support for windows 98 was infact extended to June 2006:> http://support.microsoft.com/gp/lifean1>RightAnd it was extended again last yea

Re: [GENERAL] PostgreSQL missing in SuSE 10?

f confusing.  Does anyone have information/a link to documentation that clarifies that stuff? Alex Turner NetEconomistOn 10/11/05, Gregory Youngblood <[EMAIL PROTECTED]> wrote: On Mon, 2005-10-10 at 11:04 -0700, Steve Crawford wrote:> > > Gregory Youngblood <[EMAIL PROTECT

Re: [GENERAL] PostgreSQL 8.1 vs. MySQL 5.0?

Support for windows 98 was infact extended to June 2006: http://support.microsoft.com/gp/lifean1 AlexOn 10/6/05, Joshua D. Drake <[EMAIL PROTECTED]> wrote: On Thu, 2005-10-06 at 21:40 +0300, Andrus wrote:> > Just so I know (and am armed ;) ), are there any new> > comparable features in MySQL 5.0 t

Re: [GENERAL] PostgreSQL Gotchas

Sorry. AlexOn 10/6/05, Gavin M. Roy <[EMAIL PROTECTED]> wrote: This sure sounds like a flamewar bait email?On Oct 6, 2005, at 11:07 AM, Aly S.P Dharshi wrote:> http://sql-info.de/postgresql/postgres-gotchas.html >> Any comments from folks on the list ?>> Cheers,>> Aly.>> --> Aly S.P Dharshi> [EMAI

Re: [GENERAL] PostgreSQL Gotchas

Compared to MySQL ditching referential integrity because of a typo, I would consider these 'gotchas' extremely minor, hence the reason I use Postgresql not MySQL.  Postgresql does what you expect from an RDBMS system out of the box in 99.99% of cases.  I don't have to toggle things on special like,

Re: [GENERAL] Slow search.. quite clueless

o I'm wondering if you can avoid the dereference oid lookup by created the index as keyword,product_id instead of just keyword. Alex Turner NetEconomistOn 9/20/05, Oleg Bartunov <oleg@sai.msu.su> wrote: contrib/tsearch2 ( http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ )might works f

Re: [GENERAL] character varying == text?

'foolemon', not 'foo    lemon' as I would have expected. Alex Turner NetEconomistOn 9/15/05, Tom Lane <[EMAIL PROTECTED]> wrote: CSN <[EMAIL PROTECTED]> writes:> Just something I was curious about - is there any> difference at all between "character varying"

Re: [GENERAL] Arrrr... date formatting.

Add to that they just re-released Sid Meier's Pirates, and I'm a hopeless case mateys. AlexOn 9/19/05, IanL PostgreSQL Lists <[EMAIL PROTECTED]> wrote: Alex Turner wrote:> May you find much buried treasure,Somebody PLEASE burn his Privates of the Caribbean DVD!

Re: [GENERAL] Arrrr... date formatting.

50 pieces of eight to that man there!! You are exactly right, the FM prefix is exactly what I'm seeking!  I missed that table right below the main formaing table that describes the prefixes. May you find much buried treasure, Alex Turner NetEconomistOn 9/19/05, Dianne Yumul <[EMAIL P

[GENERAL] Arrrr... date formatting.

d leave me on an island with a one-shot pistol and the sight of me sails dissapearing over the horizon! Alex Turner NetEconomist P.S. For those who didn't know - it's national talk like a pirate day.

Re: [GENERAL] Determining when a row was inserted

n't it be nice for a change to be _ahead_ of the game? Alex Turner netEconomistOn 6/3/05, Martijn van Oosterhout <kleptog@svana.org> wrote: > On 6/3/05, Wiebe de Jong <[EMAIL PROTECTED]> wrote:> >> > The way I do it is to add a timestamp field with a default value

Re: [GENERAL] Determining when a row was inserted

True, although a trigger have the benefit of being able to capture the value before it was changed allowing some measure of versioning in your data which can be a lifesaver... Alex Turner netEconomistOn 6/3/05, Wiebe de Jong <[EMAIL PROTECTED]> wrote: I don't use t

Re: [GENERAL] Determining when a row was inserted

One might even suggest that this should really be a default for all tables everywhere, because at some time or another, someone wants to know when something got put in the database... Alex.On 6/3/05, Wiebe de Jong <[EMAIL PROTECTED]> wrote: The way I do it is to add a timestamp field with a defaul

Re: [GENERAL] Storing database in WORM devices

If you simply put your database tables in their own tablespace, then move that tablespace to a WORM device, I can't see why that wouldn't work as long as you keep all the system tables etc.. on the regular RW tablespace Alex Turner netEconomist On 5/11/05, [EMAIL PROTECTED] <[EM

Re: [GENERAL] Storing database in WORM devices

I think simply initialising the system causes writes in the system tables and the WAL... I'm sure someone more knowledgeable can chime in. Alex. Turner netEconomist On 5/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Why? Any specific reason that you are aware of ? > Are

Re: [GENERAL] Hosting options on Postgres - what's best?

then pick the appropriate solution :) Alex Turner netEconomist On 5/10/05, Just Someone <[EMAIL PROTECTED]> wrote: > Hi, > > I'm looking into creating a hosted application with Postgres as the > SQL server. I would like to get some ideas and oppinions about the > diff

Re: [GENERAL] Adventures in Quest for GUI RAD

ver need (the GNUe project is implementing an > ERP system with it) > - it interfaces with basically every kind of library, interface or > whatever; you can use COM on Windows (<=> Java), Applescript on the > Mac and lots of open source applications use it as their scriptin

  1   2   >