Re: [GENERAL] Vacuum DB in Postgres Vs similar concept in other RDBMS

2007-05-26 Thread Robert Treat
> That's the only other way to do it, no? > You can also take care of the maintenence part both inline (as opposed to a seperate segment) and at commit time (rather than delay for a vacuum). See the current HOT patch for a similar implementation to this idea. -- Robert Treat Build A B

Re: [GENERAL] table partitioning pl/pgsql helpers

2007-06-01 Thread Robert Treat
there a > canonical way to > solve it? Maybe there's a trivial answer, but I have no plpgsql > programming > experience. > We I set these up for our clients, I typically seperate the partition creation piece from the data insertion piece. (Mostly as partition cr

Re: [GENERAL] Tablespaces

2007-06-05 Thread Robert Treat
the tablespace to there? Any advice would be appreciated. > > If you're not going to be spreading your installation over multiple > disks (well, mount-points), there's no need to play with tablespaces at > all. Well, one could use them as part of a disk quota utilization schem

Re: [GENERAL] When should I worry?

2007-06-12 Thread Robert Treat
orks on such an old machine. > When you're running these test, make sure to look for where your bottlenecks are. Going from a Pentium II to an Atholon may sound great, but if your bottlenecks are all i/o based, it won't give you nearly the jump you might be expecting. -- R

Re: [GENERAL] When should I worry?

2007-06-12 Thread Robert Treat
will be involved. > Would it be possible to partition this by the first_idx value? An > improvement? > It sounds like it should be possible to partition on the first_idx value (either by range or maybe a modulo type operation). It will certainly be an improvement over a single billion row

Re: [GENERAL] postgresql and solaris 10: pitch to sysadmins

2007-06-21 Thread Robert Treat
dumping some of our stuff onto our labs site, you can see some of it here: https://labs.omniti.com/trac/pgsoltools HTH -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] alter table type from double precision to real

2007-06-25 Thread Robert Treat
ahead of time) though you'll need to commit between those commands. HTH -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Experiences of PostgreSQL on-disk bitmap index patch

2007-06-25 Thread Robert Treat
s it solves an even smaller number of issues than originally hoped. my .02 anyway. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] greatest/least semantics different between oracle and postgres

2007-07-01 Thread Robert Treat
e null for Oracle enterprise 9.2.0.7 and > 10.2.0.3. > Confirmed on Oracle 8.1.7.4.0 as well, so if it changed it was a ways back. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- T

Re: [GENERAL] Standby servers and incrementally updated backups

2007-07-01 Thread Robert Treat
n primary server down for maintenance and > >> still have both a production and standby running. I guess I was > >> really just wanting to make sure I wasn't missing some other big > >> usage for incremental backups from the standby. > &g

Re: [GENERAL] [pgsql-general] In memory tables/databases

2007-07-06 Thread Robert Treat
re (in pg terms) the oid of a table would be marked so any further DML type information generated from that table is simply ignored. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Force SSL / username combination

2007-07-12 Thread Robert Treat
ng the lack of response is due to a lack of knowledge on the topic. Personally I've never quite understood how you'd make use of the sslinfo functions to manage connections without something like on commit triggers, so I hope you'll consider submitting some docume

Re: [GENERAL] Force SSL / username combination

2007-07-13 Thread Robert Treat
On Friday 13 July 2007 05:21, Gregory Stark wrote: > "Robert Treat" <[EMAIL PROTECTED]> writes: > > I'm guessing the lack of response is due to a lack of knowledge on the > > topic. Personally I've never quite understood how you'd make use of the >

Re: [GENERAL] One Large Table or Multiple DBs?

2007-07-14 Thread Robert Treat
re 75% of your buisness, your solution doesn't scale well). -- Robert Treat Database Architect http://www.omniti.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] [pgsql-advocacy] European users mailing list

2007-07-30 Thread Robert Treat
either, but seems all the emails I have seen reffered to it as the "European PostgreSQL Users Group", so I expected it to look more like other users groups, ie. [EMAIL PROTECTED] > But for now, I was asked to arrange a general mailing list, which I have >

Re: [pgsql-advocacy] [GENERAL] PostgreSQL, PGDAY, PGParty and OSCON 2007 Rocked!

2007-07-30 Thread Robert Treat
On Monday 30 July 2007 23:39, Alvaro Herrera wrote: > Joshua D. Drake wrote: > > http://www.commandprompt.com/images/oscon_2007.png > > > Left to right: Michael from UGA > (surely everyone knows what UGA is, right?), Josh Berkus, Jim Nasby, > Josh Drake, David Fetter, Rob

Re: [GENERAL] Add Column BEFORE/AFTER another column

2007-08-24 Thread Robert Treat
pen to know an ambituous C hacker, there is a good chance it could be included in 8.4. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Add Column BEFORE/AFTER another column

2007-08-25 Thread Robert Treat
On Saturday 25 August 2007 01:40, Jaime Casanova wrote: > On 8/24/07, Robert Treat <[EMAIL PROTECTED]> wrote: > > On Friday 24 August 2007 17:18, Matthew wrote: > > > Hey Bill, > > > > > > > It does not. > > > > > > Bummer. >

Re: [GENERAL] PostgreSQL Glossary?

2007-09-15 Thread Robert Treat
xists, but someone could certainly start one. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Migration from PervasiveSQL

2007-09-21 Thread Robert Treat
use the built in csv import > through pg via COPY). > > barring that you need to roll some scripts or use a tool. There are > many ways to do this of varying quality, mostly pretty dubious. In > the microsoft world you have DTS which has an ok migrator. > Perhaps odbclink c

Re: [GENERAL] Migration from PervasiveSQL

2007-09-22 Thread Robert Treat
On Friday 21 September 2007 22:43, Merlin Moncure wrote: > On 9/21/07, Robert Treat <[EMAIL PROTECTED]> wrote: > > On Thursday 20 September 2007 18:38, Merlin Moncure wrote: > > > On 9/20/07, Collin <[EMAIL PROTECTED]> wrote: > > > > Well, the su

Re: [GENERAL] Migration from PervasiveSQL

2007-09-24 Thread Robert Treat
On Sunday 23 September 2007 23:43, Ow Mun Heng wrote: > On Sat, 2007-09-22 at 16:05 -0400, Robert Treat wrote: > > On Friday 21 September 2007 22:43, Merlin Moncure wrote: > > > On 9/21/07, Robert Treat <[EMAIL PROTECTED]> wrote: > > > > On Thursday 20 Septem

Re: [GENERAL] Support for distributed transactions in 8.2.5

2007-10-11 Thread Robert Treat
thinking about pl/proxy, which you interface at the sql level like other procedures, and it does some magic behind the scenes to farm queries where they are supposed to go. Granted this doesn't really support acid safe distributed dml, but might be what he was thinking? -- R

Re: [GENERAL] SLEEP in posgresql

2007-10-14 Thread Robert Treat
t tends to be resource intensive. Better would probably be to use an external lang, like this: CREATE OR REPLACE FUNCTION otools.sleep(integer) RETURNS integer AS $$ my ($seconds) = @_; return sleep($seconds); $$ LANGUAGE 'PLPERLU'; -- Robert Treat Database

Re: [GENERAL] subversion support?

2007-10-29 Thread Robert Treat
at would work for you? -- Robert Treat Database Architect http://www.omniti.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Migration questions for upcoming 8.3 release and fts

2007-10-29 Thread Robert Treat
mps for doing the upgrade. Not that much different than going from 8.1 -> 8.2, which I have blogged about previously. HTH. -- Robert Treat Database Architect http://www.omniti.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] young guy wanting (Postgres DBA) ammo

2007-11-03 Thread Robert Treat
this stuff, but since PostgreSQL's typical usage has leaned more toward solving larger/more complex problems, the idea that you would have a DBA standing behind it generally has been true in far more cases. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware

Re: [GENERAL] Regression in 8.3?

2007-11-12 Thread Robert Treat
t; makes both of us say clearly what we want. > > > > If people want it they can add the automatic cast back in, it just > > isn't dfault anymore. > Any recommendations on how one might go about generating a list of all of the removed implicit casts? -- Robe

Re: [GENERAL] PITR and warm standby setup questions

2007-11-12 Thread Robert Treat
lay mode (for example, during a failover scenario) the server often has a desire to reread the last file you processed, and if you dont have it complains. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)---

Re: [GENERAL] Tools for dumping pg_xlog, pg_clog, etc?

2007-11-29 Thread Robert Treat
gt; -- > > http://www.wiesinger.com/ > > > > On Fri, 18 May 2007, Gerhard Wiesinger wrote: > >> Hello! > >> > >> Are there any tools available to dump the files of the pg_xlog, pg_clog, > >> ... directories in human readable format to unde

Re: [GENERAL] PostgresSQL vs Ingress

2007-11-29 Thread Robert Treat
technology standpoint, Ingres is top notch, but it suffers from the same problem as most of the database solutions available; it is corporate owned/controlled rather than community owned/controlled. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} Postg

Re: [GENERAL] Postgres WarmStandby using ZFS or Snapshot to create Web DB?

2007-12-02 Thread Robert Treat
a 1TB Sybase database, its warm-standby > and regular backups & quarterly maintenance. I am new to PostGres and the > idea of no tech support phone calls when things break is a scary one! I am > trying to create a belt-and-suspenders redundant solution so that if > something br

Re: [GENERAL] Conservative postgresql.conf made by initdb?

2007-12-04 Thread Robert Treat
; "persistent" and hence many of which are idle at the low hours? > Nah, initdb is not a tuning device. I'd recommend setting your shared_buffers to 20% of total RAM for starters. You'll also want to set your expected_cache_size accordingly. After that, google and benchmarkin

Re: [GENERAL] 8.3 release notes

2007-12-04 Thread Robert Treat
f them show what redirect_stderr was renamed to. It > says something like "... was renamed to foo. redirect_stderr was renamed > to bar was renamed to ..." Yeah, that should get cleaned up. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL --

Re: [GENERAL] Moving pgstat.stat and pgstat.tmp

2007-12-04 Thread Robert Treat
on the system... uncovered in much the same way... go solaris). Actually I was wondering if it could be done with symlinks, a la moving xlogs. Since we do custom builds, that's not a real issue, but I was curious. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} Postgre

Re: [GENERAL] Moving pgstat.stat and pgstat.tmp

2007-12-05 Thread Robert Treat
On Wednesday 05 December 2007 07:22, Alvaro Herrera wrote: > Robert Treat wrote: > > On Monday 03 December 2007 20:22, Erik Jones wrote: > > > Interesting. If this is anything you'd like to look into I can > > > provide whatever diagnostic output you need (ios

Re: [GENERAL] Re-partitioning huge schema

2007-12-05 Thread Robert Treat
ective, partitioning on id ranges v. using the bin > partitioning method are kind of similar. The biggest differences > being that with the range setup the majority of the working set of > data will be in the last couple of month's partitions whereas with > the bin method it will be

Re: [GENERAL] Re-partitioning huge schema

2007-12-07 Thread Robert Treat
Personally I've not yet landed a customer who needs such a solution, but hopefully soon) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, plea

Re: [GENERAL] Continual Postgres headaches...

2007-12-07 Thread Robert Treat
dark. > just to add, make sure your free_space_map settings are set adequately; otherwise you might not be able to find an adequate schedule. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)---

Re #3: top posting (was: [GENERAL] Hijack!)

2007-12-11 Thread Robert Treat
out the objective > superiority of one method over another. I think we should also avoid being > too doctrinaire about it. > Adding something to the FAQ/Subscribe message certainly couldnt hurt. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re #2: top posting (was: [GENERAL] Hijack!)

2007-12-11 Thread Robert Treat
n appropriate >subscribe-nomail command to [EMAIL PROTECTED] so that your >message can get through to the mailing list cleanly You criticize that Joshua's reply was dogmatism but was yours any better? I think people can see through these weak ad hominem arguments; no

Re: [GENERAL] top posting

2007-12-11 Thread Robert Treat
o trim accordingly, you're already at the bottom of the email, and so bottom posting comes more naturally. *shrug* -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] partitioned table query question

2007-12-12 Thread Robert Treat
do a select with where bin_id = mod(2112,3); Where 2112 equals the number your looking for, and 3 would be the number of buckets. -- Robert Treat http://www.omniti.com/ We're Big. On PostgreSQL. ---(end of broadcast)--- TIP 3: Hav

Re #1: top posting (was: [GENERAL] Hijack!)

2007-12-12 Thread Robert Treat
posting may well > cause your messages to be ignored. Those claims are both true, and we > don't need to justify it with jumped-up claims about the objective > superiority of one method over another. I think we should also avoid being > too doctrinaire about it. > > A > &

Re: [GENERAL] index organized tables use case

2007-12-12 Thread Robert Treat
ere is the techniques that are available in Postgres that might help keep the same schema performant. I think looking at partitioning or at partial indexing (making a new index on the code clause) could help keep performance with minimal impact to the schema. -- Robert Treat Build A Bright

[GENERAL] phpPgAdmin 4.2-Beta-1 translation status

2007-12-19 Thread Robert Treat
e or the phppgadmin developers at [EMAIL PROTECTED] Thanks in advance. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subs

Re: [TLM] Re: [GENERAL] How to insert on duplicate key?

2007-12-28 Thread Robert Treat
way to determine if there are live transaction looking at the row, that would require quite a bit of knowledge about what else is occuring in the system to be able to determine that. That level of knowledge/complexity is what vacuum takes care of. -- Robert Treat Build A Brighter LAMP :

Re: [GENERAL] Experiences with extensibility

2008-01-08 Thread Robert Treat
include synonyms and packages as possible items we don't have which would make us more extensible, but the uses for those tools that can't be covered with the tools available in postgres is pretty narrow. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL --

Re: [GENERAL] Kernel kills postgres process - help need

2008-01-09 Thread Robert Treat
inux has a behavior -- which in my opinion is a bug -- that > > causes the OOM killer to almost always kill PostgreSQL first, > > regardless of whether it was truly the offending process or not. > > If that isn't an argument for FreeBSD I don't know what is... > Funn

Re: [GENERAL] Storing and querying boolean fields

2008-01-09 Thread Robert Treat
a more current version as soon as possible, or to seek support from a commercial support vendor who is willing to continue backpatching for them." -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--

Re: [GENERAL] advocacy: drupal and PostgreSQL

2008-01-15 Thread Robert Treat
started to pay off. I'd guess that if they wanted to, they could switch to PDO with Drupal 7 and not hurt themselves too much. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-16 Thread Robert Treat
business factors. My guess is that in your case, you'd want a mix of replicating data from the current Oracle database and your application, as best possible. Figuring out how you go about replicating the data is certainly easier if you've have been through it before, but I don't thin

Re: [GENERAL] WARNINGs after starting backup server created with PITR

2008-01-19 Thread Robert Treat
second co-lo for now. But, pretty soon we're > going to be surpassing the available limits in portably drive > capacity unless we invest in tape drives. > Are you guys running ZFS yet? If so it's snapshot / cloning capabilities might be the way to go. -- Robert Treat Build A

[GENERAL] Looking for PostgreSQL Folks in New Orleans area

2010-11-09 Thread Robert Treat
Howdy folks, We're looking for some PostgreSQL users / advocates in the New Orleans area for some community outreach activities, like PGDays and User Groups. If you are in that area and interested in helping, or know who to talk to, please drop me a line, thanks! Robert Treat play:

Re: [GENERAL] Why facebook used mysql ?

2010-11-10 Thread Robert Treat
be somewhat workload dependent. It's mostly irrelevant though to "internet oriented" companies, very few are looking for 32+ core systems as a solution to their problems. Robert Treat play: http://www.xzilla.net work: http://www.omniti.com/is/hiring

Re: [GENERAL] REINDEX requirement?

2010-11-10 Thread Robert Treat
ill output numbers on table/index bloat. It's not entirely accurate (patches welcome), but usually good enough to highlight the problems. See http://labs.omniti.com/labs/pgtreats/log/trunk/tools/pg_bloat_report.pl Robert Treat play: http://www.xzilla.net work: http://www.omniti.com/is/hiring

Re: [GENERAL] PGError: ERROR: missing FROM-clause entry for table

2010-11-25 Thread Robert Treat
is_cadex_released LIMIT 5 OFFSET 0 > Looks to me like the problem is you are trying to ORDER BY columns in "ca_customs_entry", but there is no such table for that (don't confuse it with "ca_customs_entries"). You need to either set a matching alias, or fix the table name qualifier in those order by columns. Robert Treat play: xzilla.net work: l42.org/lg

Re: [GENERAL] PG on two nodes with shared disk ocfs2 & drbd

2011-02-27 Thread Robert Treat
someone is looking to fund/help development of such a thing, it might be worth pointing people to Postgres-XC (http://wiki.postgresql.org/wiki/Postgres-XC). It's got a ways to go, but they are at least trying. Robert Treat play: xzilla.net work: omniti.com hiring: l42.org/Lg -- Sent via pgsq

Re: [GENERAL] Question about switchover with PG9 replication

2011-02-27 Thread Robert Treat
The issue is more just that the built in replication system isn't very mature yet. It's being worked on, and switchover is something on the list, but it's not an option yet. Robert Treat play: xzilla.net work: omniti.com hiring: l42.org/Lg -- Sent via pgsql-general mailing list

Re: [GENERAL] Oracle to PostgreSQL transition?

2013-04-05 Thread Robert Treat
x27;s the latter, you'll probably need to write your own tools; at least we've always done that as we've never found anything that worked with both Oracle and MSSQL into Postgres reliably; but really it shouldn't be too difficult; basically just ETL or some home brew repli

Re: [GENERAL] upgrading from V8.3.4 to V9.2.4

2013-04-05 Thread Robert Treat
gsql was port to use the core lexer. Ideally you'll have some kind of test suite / regression you can run to verify all of this; if not you maybe you can set up some replication between old/new servers (we use mimeo for that when sever versions are this far apart) and point your app to both a

Re: [GENERAL] postgresql book - practical or something newer?

2008-01-31 Thread Robert Treat
d I > bought a bit of it too, didn't bother subscribing to safari, it just > ain't a book!) to be used as reference and what not. > > In PG, all there is, is the manual, a book by Robert Treat, the Book > from Joshua, 1 or 2 other books authored by someone I can't rem

Re: [GENERAL] Performance problems with Postgresql/ZFS/Non-global zones on Solaris?

2008-02-02 Thread Robert Treat
gt; > > > like > > > > commit_delay, > > > > fsync. > > I haven't done any tuning as of yet. I'm running with the default settings > produced by initdb. > Don't even bother trying to tune zfs untill after you've tuned postgres,

Re: [GENERAL] [pgsql-advocacy] PostgreSQL Certification

2008-02-04 Thread Robert Treat
t put > use.perl.org in the top results. > hmm, i'd have thought you would have wanted planet.perl.org anyway (though that doesn't show up either) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---(end of broadcast)--

Re: [GENERAL] Is PG a moving target?

2008-02-11 Thread Robert Treat
was the idea behind castcompat, which didn't get far out of the gate before several examples cropped up showing how backwards-compatible casting would break new 8.3 system expectations. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL --

Re: [GENERAL] end of life for pg versions...

2008-02-12 Thread Robert Treat
p://www.postgresql.org/ I'd place it in the support menu... Actually I think we should be pointing people to http://www.postgresql.org/developer/roadmap. Of course we would still need to add an EOL page... I think one could make a strong argument for a static url for EOL info now tha

Re: [GENERAL] TSearch2 Migration Guide from 8.2 to 8.3

2008-02-12 Thread Robert Treat
module.) > Note another possible solution for mediawiki users is to do a fresh install using latest svn, which has native 8.3 fts support for postgres, and then do an xml dump/import of the wiki contents. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Re: [GENERAL] postgresql book - practical or something newer?

2008-02-19 Thread Robert Treat
te for it, and the public doesn't want to commit > to a database that has only a handfull of books available. > Just to clarify, the market needs to expand to get publishers on board, not authors. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL --

Re: [GENERAL] Trigger to run @ connection time?

2008-03-16 Thread Robert Treat
n escape from the failure scenario by having either a different role, or a different database with the ability to do "alter database disable on connect triggers". whether this is a direct alter database, or set at the GUC level, either makes it pretty hard to lock yourself out completly,

Re: [GENERAL] Postgresql partitioning

2008-03-22 Thread Robert Treat
update rule to the parent table itself, rewriting into a set of insert, delete statements. (or call a function to manage it which is probably better on a larger number of partitions) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailin

Re: [GENERAL] Postgres development

2008-03-22 Thread Robert Treat
as been pestering him about it pretty steady. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- 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] Re: Survey: renaming/removing script binaries (createdb, createuser...)

2008-03-27 Thread Robert Treat
t E'\\connect ' || datname || E'\nvacuum;' from > pg_database where datallowconn" | psql > > that's not actually complicated (i'm not saying it's nice, as it isn't). > I have to think that a better solution for someone whose needs are met by the abo

Re: [GENERAL] pgcrypto and dblink

2008-04-14 Thread Robert Treat
sing configure. > A post installation step is fine but I think it needs to be documented > as such. > There are instructions on how to install them at http://www.postgresql.org/docs/8.3/interactive/contrib.html, but your right they don't seem to be mentioned anywhere in the install s

Re: [GENERAL] How to modify ENUM datatypes?

2008-04-23 Thread Robert Treat
s ever (yeah, i > > skipped some special cases). > > I was gonna say ! :-) > > Add > > hermaphrodite > transgender with female phenotype > transgender with male phenotype > > and you should be set from current medical science's point > of view ;-) > T

Re: [GENERAL] Column order

2008-04-23 Thread Robert Treat
its and you'll have soon have a patch for doing this the right way. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- 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] How to modify ENUM datatypes?

2008-04-26 Thread Robert Treat
argue that since it is expected that the ratings might change in some way every few years that an enum type is not a good choice for this, but I feel like some type of counter-argument is that this is probably longer than one would expect thier database software to last. :-) -- Ro

Re: [GENERAL] How to modify ENUM datatypes?

2008-04-29 Thread Robert Treat
On Monday 28 April 2008 17:35, Jeff Davis wrote: > On Sat, 2008-04-26 at 20:33 -0400, Robert Treat wrote: > > I think one of the best examples of this is the movie rating system > > (which I blogged about at > > http://people.planetpostgresql.org/xzilla/index.php?/archives/3

Re: [GENERAL] How to modify ENUM datatypes?

2008-04-30 Thread Robert Treat
On Monday 28 April 2008 10:28, Andrew Sullivan wrote: > On Sat, Apr 26, 2008 at 08:33:28PM -0400, Robert Treat wrote: > > enum types custom ordering. It also showcases the idea of data > > definitions that "should never change", but that do changes every half > >

Re: [GENERAL] How to modify ENUM datatypes?

2008-05-01 Thread Robert Treat
On Thursday 01 May 2008 01:30, Greg Smith wrote: > On Wed, 30 Apr 2008, Robert Treat wrote: > > Whenever anyone posts a problem on 7.3, the first thing people do now > > days is jump up and down waving thier arms about while exclaiming how > > quickly they should upgrade. Whi

Re: [GENERAL] How to modify ENUM datatypes?

2008-05-01 Thread Robert Treat
On Wednesday 30 April 2008 11:00, Craig Ringer wrote: > Robert Treat wrote: > > If one were to have built something on postgresql 5 years ago, they would > > have had to do it on 7.3. Whenever anyone posts a problem on 7.3, the > > first thing people do now days is jump up

Re: [GENERAL] How to modify ENUM datatypes?

2008-05-01 Thread Robert Treat
On Thursday 01 May 2008 13:40, Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > > And again, if you do the math, any install before 2008-11-17 would have > > been on 7.3, which is less than 5 years. > > I'm not sure how you're doing the math, but

Re: [GENERAL] Is this possible in a trigger?

2008-05-06 Thread Robert Treat
; You can't in plpgsql. It doesn't have the equivalent of a walkable > fields collection. Its possible in some other procedure languages (I've > seen it done in C). > I did it once by setting up the function to accept the tablename and ctid of the row involved, and then g

Re: [GENERAL] pg_standby / WAL archive-restore through system restarts

2008-05-13 Thread Robert Treat
gt; > There is a caveat here, in that you need to keep around n number of xlogs, where n is determined based on the last restart point processed on the slave. If you are deleting all xlogs as they are processed, any shutdown will likely cause you to have to start the whole thing over again. Not

Re: [GENERAL] PG -v- MySQL

2008-05-13 Thread Robert Treat
to find information specific to your environment). It's an understandably difficult issue to work around, since ever storage engine you use means that you're basically learning the intricacies of a separate database, so it doesn't surprise me that things end up a little schizophren

Re: [GENERAL] Alias in the HAVING clause

2008-05-14 Thread Robert Treat
l problems the spec is trying to keep you from getting into... but I have to wonder, if we have established f1 by the time we evaluate the group by, shouldn't we also be able to determine f1 at having time, and therefore allow alias in having in this instance? -- Robe

Re: [GENERAL] Losing data

2008-06-19 Thread Robert Treat
ms to have started last friday, when reports started to go > missing. Out of curiosity, what is your vacuum strategy? -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your s

Re: [GENERAL] limits?

2008-06-25 Thread Robert Treat
eeps creating empty tables and see where > that goes, but I'd prefer not to do something like this... > http://people.planetpostgresql.org/greg/index.php?/archives/37-The-million-table-challenge.html -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via p

[GENERAL] Volunteers needed to help staff the PostgreSQL Booth at LISA 2009

2009-10-09 Thread Robert Treat
l day Wednesday (November 4th, Noon - 7PM) and half day Thursday (November 5th, 10AM-2PM). You get a Postgres T-shirt for your trouble, and the opportunity to talk with lots of people interested in getting started with Postgres. Please reply to this email if you've got some time. Thanks!

Re: [GENERAL] SSDs with Postgresql?

2011-04-28 Thread Robert Treat
xlogs streams are in 16mb bursts. It would make more sense for wal streaming though (but in that case we'd probably want to measure it more precisely). Robert Treat play: http://xzilla.net work: http://omniti.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] SSDs with Postgresql?

2011-04-29 Thread Robert Treat
re running fusion-io on some pretty heavily traffic'd servers, and the performance has been good, and durability there when needed. It's certainly worth checking out for those investigating these options. Robert Treat conjecture: xzilla.net consulting: omniti.com -- Sent via pgsql-gene

Re: [GENERAL] md5 of table

2011-09-01 Thread Robert Treat
ons. I've always liked doing this with my pager: [robert@client-168] export PAGER=md5 -=[11:40:25 Thu Sep 01]=---=[ pagila-0.10.1 ]=- [robert@client-168] psql -hlocalhost -dpagila psql (9.0.4, server 9.1beta3) WARNING: psql version 9.0, server version 9.1. Some psql features m

Re: [GENERAL] PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4

2011-09-14 Thread Robert Treat
Can you go into some more detail on how you set up ZFS on these systems? Robert Treat conjecture: xzilla.net consulting: omniti.com On Tue, Sep 13, 2011 at 10:56 PM, Andy Colson wrote: > On 09/13/2011 08:15 PM, Toby Corkindale wrote: >> >> Hi, >> Some months ago, I ran

Re: [GENERAL] Default timezone changes in 9.1

2012-12-22 Thread Robert Treat
here system was UTC and Postgres was GMT, which was mostly a cosmetic problem, but it surprised us elsewhere too). It makes me wonder if there was enough thought put into the backwards compatibility angle of this; either what the default should be, or to make sure people were aware of the

Re: [GENERAL] [pgsql-advocacy] [pdxpug] Pg booth staffing at OSCON

2008-07-15 Thread Robert Treat
nce and for all.... sumo suits anyone? http://www.maineventweb.com/page/page/2916926.htm -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- 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] Must be table owner to truncate?

2008-07-30 Thread Robert Treat
difference between an unqualified DELETE and a TRUNCATE? > > lack of triggers and RULEs spring to mind. > Just fyi, there is a patch for 8.4 that will add truncate permissions. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-gen

Re: [GENERAL] Using PostGres general distribution

2008-07-31 Thread Robert Treat
't designed into your original expectations; but if you have controlled access to the server, it's likely postgres can work in that scenario. (The other problem spots is server upgrades, but you can probably go years on a particular version before that becomes really pr

Re: [GENERAL] [EMAIL PROTECTED]

2008-08-04 Thread Robert Treat
Hiroshi-san, Is this something specific to windows? If so, should this be consider a bug? Robert Treat On Sunday 03 August 2008 18:01:05 Hiroshi Saito wrote: > Hi. > > Sorry, it was not included in release. > please see, > http://winpg.jp/~saito/pg_work/OSSP_win32/ > > Reg

Re: [GENERAL] mailing list/newsgroup disconnect

2008-08-10 Thread Robert Treat
list and not to me personally). > > Is there someone I should mention this to or does he already know? > Problems like this should be reported to [EMAIL PROTECTED] It would likely be helpful to include emails with full header information, though the folks there can tell you what they nee

Re: [GENERAL] New to postgres -' how to' tips needed

2008-08-21 Thread Robert Treat
cific questions beyond that, please post them in the list, and be sure to include your OS and version information. HTH :-) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- 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] Oracle and Postgresql

2008-09-02 Thread Robert Treat
g simple like oracle's dblink, which comes pre-installed, is simple to set-up, and has a much more straight-forward syntax for use in day to day query work. -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL -- Sent via pgsql-general mailing list (pgsql-genera

  1   2   3   4   >