that doc patches be
> > sent to -docs.
> >
> > What say?
>
> I say no, because whilst some comments should (and do) end up in the docs,
> many are simply useful real-world code examples and related information that
> people post. It's useful stuff, but would clutter
ting around that allowed seqscans to start in
the middle of a table if it was detected that a seqscan on that table
was already in progress. Not sure if that made it in, but it might be
relevant here.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pe
careful of.
Just make sure you increase max_fsm_relations, and that max_fsm_pages is
at least > max_fsm_relations, because each relation must get at least
one page.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-
e hardware and not with postgresql but I
> don?t want to restore all the database.
>
> How is the best way to fix? pg_resetxlog?
>
> Thanks in advance!
>
> Reimer
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.co
change CHUNKPAGES in
include/storage/freespace.h to 1. That means you could get by with 2M
pages, which is 'only' 16GB.
Perhaps it would be worth considering some alternatives to how the FSM
works. In particular, it might be worth it to be able to store free
space info for multiple rel
ot; and "-compatv3" switch to
> make it behave like the older MySQL flavors.
>
> This defaulting to running like an old version, with all its issues is
> one thing that makes MySQL so unnattractive to use. That and the fact
> that if you've got a problem, the
; > /**
> >* @hibernate.id generator-class="native" column="id"
> >*/
> > public Long getId() {
> > return id;
> > }
> >
> > public void setId(Long long1) {
> > id = long1;
> > }
> >
> > /**
s thrashing of the storage allocations (the reason
given for using CHUNKPAGES in the first place).
Perhaps an interum fix might be to ignore CHUNKPAGES for any relation
that would only be getting one chunk, and just give it the exact number
of pages it needs.
--
Jim C. Nasby, Sr. Engineering Consul
t1.to_date) overlaps
> test$#(t2.from_date, t2.to_date)) )$$;
On a small dataset you may not notice much difference, but you'll
certainly see it on a large dataset.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.co
I think I have to use PostgreSQL 7.4.7.
Well, you might be able to buy support for 8.1 on RHEL 2 from someone
other than Red Hat, if support is your primary concern. In any case, you
do not want to be using 7.4.7, since there's data corruption bugs that
have been fixed since then. I'd hope
of AMD or Intel server
> CPUs as far as postgresql performance is concerned? Is it worthy or not?
-performance would be a better place to ask, so I'm moving this there.
The general consensus is that your best bet CPU-wise is Opterons.
--
Jim C. Nasby, Sr. Engineering Consultant [EMA
s, so they're something that more people are familiar with. They
also support other databases, making comparisons easier.
[1] http://sourceforge.net/projects/osdldbt
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://perv
nt storage (ie: the database) periodically, that would probably
be a good option for you. Another possibility is using something like
SQLite just for storing the session info (though I think it's MVCC based
as well, so it might have just as much difficulty with this as
Post
n cannot pass our
position --- if it
access/nbtree/README:(see btbulkdelete).
[EMAIL PROTECTED]:50]~/pgsql/HEAD/src/backend:7%
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
rtunately, the primary key column for the table
> is not unique across all dataset databases, so a model id used to identify a
> car model in the car database may also identiffy a van model in the van
> database.
BTW, you might also find inheritance to be of use:
http://www.postgresql.or
On Mon, Mar 27, 2006 at 03:16:29PM +0300, Devrim GUNDUZ wrote:
> Hi,
>
> On Mon, 2006-03-27 at 06:03 -0600, Jim C. Nasby wrote:
> > I'd hope that RH would support at least the
> > most recent version of 7.4, since presumably that's part of what they
> > pay T
od XML support, for example. And of course there's java...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of b
On Mon, Mar 27, 2006 at 03:46:17PM +0200, Alban Hertroys wrote:
> Jim C. Nasby wrote:
> >On Fri, Mar 24, 2006 at 11:25:35AM -0700, [EMAIL PROTECTED]
> >wrote:
> >
> >If you only want to know if something exists, do NOT use count!
> >
> >
> >>
e latest point release. There's a number
of data corruption bugs that have been fixed since 7.3.0.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pe
f it that has a slightly different structure?
>
> My first guess would be to create the empty new version of the db and
> insert the data of the old one into it - adding and modifying it when
> necessary, but I am not sure.
>
> What do you usually do in a situation like this?
ALT
ure eg.
> there are two new columns that needs data?
Depends on how much data you need to modify. For small tables, I stick
with ALTER TABLE because it's a lot cleaner/easier. For larger tables,
you might want to CREATE TABLE AS SELECT ..., or maybe copy out and copy
back in.
--
t; 2.7696590423584
Ok, so that tells me that on this plain-vanilla hardware, you can
'only' do 3600 queries per second from PHP.
Who cares?
If you're actually trying to run that kind of volume on that kind of
hardware, you need to reconsider what you're doing.
--
Jim C
c_fid USING SRID=-1
>
> Error::ERROR: syntax error at or near ")" at character 333
Extra ) after the the last ON.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.na
http://www.postgresql.org/docs/8.1/interactive/backup-online.html
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
--
roadcast)---
> > TIP 4: Have you searched our list archives?
> >
> >http://archives.postgresql.org
> --- End of Original Message ---
>
>
> ---(end of broadcast)-
gt;
> Thanx in advance,
>
> Alexander.
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>
ht make a
lot of sense, so long as there's very littly querying across partitions.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell
ertainly people out there running multi-terrabyte databases on
PostgreSQL. Unless there's a sound technical reason to switch, I'd stick
with PostgreSQL, especially because migrating to Oracle from PostgreSQL
is fairly easy.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasiv
both remote and local access.
Users don't matter at all for temp tables. Temp tables are per
*session*, so as soon as you come in from a different connection it's a
different set of temp tables.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software
r products. Plus the support on these mailing lists is
absulutely top-notch.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
I believe CHECKPOINT is protected since repeatedly calling it could
result in performance problems, but you can probably get around that if
needed by using a security-definer function.
Why do you want non-superusers to be able to checkpoint, anyway?
--
Jim C. Nasby, Sr. Engineering Consultant
On Mon, Apr 24, 2006 at 07:15:12PM -0400, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > Some food for thought: http://sql-info.de/mysql/gotchas.html
> >
> > Something else to consider is that there's a number of options open to
> > you for getting commercial Postg
On Tue, Apr 25, 2006 at 09:31:48AM +0800, Qingqing Zhou wrote:
>
> ""Jim C. Nasby"" <[EMAIL PROTECTED]> wrote
> > On Mon, Apr 24, 2006 at 06:16:30PM +0800, Qingqing Zhou wrote:
> > > Is it possible to have a superuser who could do CHECKPOINT, BACKU
ther good os-db.)
>
> it is client and serverside.
>
> tnx,
>
>
>
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTE
7;s some PostgreSQL gotchas as
well, but there's far fewer and they're nowhere near as serious).
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
periodically recluster by issuing the command again.
There is absolutely no way to enforce any kind of table ordering in
PostgreSQL as soon as you do *anything* that changes the table.
And like others said, I think you need to re-think how you're doing
this... :)
--
Jim C. Nasby, Sr. Engineer
gt; config options). Potentially different compilers (used to build Postgres on
> the two systems) could cause problems as well (by changing structure layouts).
And make sure you test thoroughly... there are built-in checks to detect
any incompatabilities, but most people don't try stuff like t
8.1.2 everything is
> working fine, but the version of pg_dunp is 7.4
>
> How do i upgrade pg_dump so I can dump / backup the database?
>
> Thanks
>
> Bob
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork:
autovacuum logging? It sure would be nice to be able
> to verify that tables are being vacuumed properly without having to
> set the log level to DEBUG2.
>
> Will Reese -- http://blog.rezra.com
>
> -------(end of broadcast)---
and then stop?
You'll probably need to re-create the appropriate files and then
REINDEX. This is the only disk where you have any real chance of
recovering from a failure without losing data (other than the binaries).
Now the real question is: why are you trying to run without raid?
--
dump so that it dumps
queue tables first. Once a table is dumped pg_dump shouldn't need to
access it again, so it's theoretically possible to make the "I promise
not to access these tables" list dynamic during the life of a
transaction; as pg_dump finishes with tables it could then pr
{ print $0;}'
There's been talk of allowing a finer-grain selection of what pg_dump
will dump, but I don't think there's anything in there right now to
support that.
What's wrong with using awk like you are?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECT
ovided vacuum hasn't nuked anything that old you should
theoretically be able to get a consistent view of data, excluding some
things like TRUNCATE.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://j
CMS have that high an update rate anyway? I'd think it would
only be somewhere between 10% and 25% DML...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell:
m not sure of the details.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)--
me in whatever unit
> - Select count(id) from test - time in whatever unit
> - Table size - kb=?
> - Index size - kb=?
> - omit or add whatever makes/doesn't make sence here (eg. memory
> required to do the select?, time to vacuum?)
>
> and the same thing wi
za nella normalit?, c'? solo monotonia.
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)-
On Wed, May 03, 2006 at 04:28:10PM +0200, Leif B. Kristensen wrote:
> However, I'm wondering if there's a practical limit to how many rows you
> can insert within one transaction?
I believe transactions are limited to 4B commands, so the answer would
be 4B rows.
--
Jim C. Nasby,
rom the machine? I mean, why is
> it only taking 3% of them.
Because a server has more than just CPU as a resource. In this case you
were undoubtedly limited by the drives that pg_xlog is on.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://per
ry.org/projects/my2postgres/ ?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)---
On Thu, May 04, 2006 at 03:30:34PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > I'd actually been thinking about this recently, and had come up with the
> > following half-baked ideas:
>
> > Allow a transaction to sp
rticle.aspx?id=10087&query=vacuum
As for the setting, did you have PostgreSQL reload the config file?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
"it'll
only be a small site"...
> I read in a few places that vacuuming on a heavily hit site can be
> necessary several times a day; and so that has been my biggest concern
> with PostgreSQL. I haven't previously used autovacuum.
Autovacuum is your friend. I would s
On Thu, May 04, 2006 at 10:58:24PM +0200, Leif B. Kristensen wrote:
> On Thursday 04 May 2006 22:30, Jim C. Nasby wrote:
> >On Wed, May 03, 2006 at 04:28:10PM +0200, Leif B. Kristensen wrote:
> >> However, I'm wondering if there's a practical limit to how many rows
&g
more expensive options.
>
> You want an in-depth comparison of how a server disk drive is internally
> better than a desktop drive:
>
>
> http://www.seagate.com/content/docs/pdf/whitepaper/D2c_More_than_Interface_ATA_vs_SCSI_042003.pdf
BTW, someone (Western Digital?) is now offering S
a valid concern, since the backup will
be nowhere near as up-to-date as the database was unless you have a
pretty low DML rate.
> BUT a hardware controler is about EUR2000 and a (ATA/SATA) 500GB HD
> is ~ EUR350.
Huh? You can get 3ware controllers for about $500, and they're pretty
dec
get
'server reliability' in some of their SATA drives, but maybe now
everyone's starting to do it. I suspect the premium you can charge for
it offsets the costs, provided that you switch all your production over
rather than trying to segregate production lines.
--
Jim C. Nasby, Sr. Eng
n if it did, if the OS was
catching them I'd hope it would pop up a warning or something. But from
what I've heard, some drives now-a-days will silently remap dead sectors
without telling the OS anything, which is great until you've used up all
of the spare sectors and there's nowh
IIRC, so
anything else that's hitting the table will have to finish before the
reindex can start.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell:
mples of implementation of PQtrace.
Since no one's replied... you might have better luck on
pgsql-interfaces. Unfortunately I don't know very much about PQtrace...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-
ews and constraints alone, use them.
Or maybe more accurately, do what you have the expertise for. If you've
got a good database developer on staff there's a lot to be said for
putting stuff into procedures, especially if it's database-intensive.
--
Jim C. Na
e all the
other locations subscribe to it.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---(end of broadcast)--
d to stick with 7.4 you should at least be running the most current
version.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---
tore.
>
> Does anyone know how to concatenate WAL contents, i.e. decode and encode
> WAL files using the address of backup files (aaa in x.aaa.backup
> files)?
It's not possible to do multi-master WAL-based replication, because it
describes table changes at a binary level.
-
m there if need be).
There's been some discussion about allowing EXPLAIN to produce
machine-readable output, probably in XML. I agree that it would be a lot
easier if there was some way you could take explain output and plug it
into some tool that would present an easier to understand fo
any other project aiming to create friendly catalog views?
Not oracle views, but there is
http://pgfoundry.org/projects/newsysviews/ .
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/perva
#x27;s what a laptop should be;
plenty of screen real estate but also thin and light.
Then I started using OS X and came to realize (to quote from Jurasic
Park) "this is unix, I know this!"
Granted, when it comes to administration it's a fair bit different, but
I think OS X is abou
On Mon, May 15, 2006 at 10:14:05PM -0500, Russ Brown wrote:
> On Mon, 2006-05-15 at 17:12 -0500, Jim C. Nasby wrote:
> > On Wed, May 10, 2006 at 02:08:46PM -0300, Bruno Almeida do Lago wrote:
> > > Sometime ago I saw a project with the purpose of creating Oracle views
&g
)
And if you do think you need OID, you should probably be asking yourself
why, as it's been recommended not to use it since around 7.4.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.n
ory you have, but you need to
be careful with *work_mem, as being too agressive can run the machine
out of memory.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervas
On Tue, May 16, 2006 at 07:24:43PM -0400, Sean Davis wrote:
> Jim C. Nasby wrote:
> >On Tue, May 16, 2006 at 03:41:07PM -0400, Sean Davis wrote:
> >
> >>I had cranked things up a bit from the standard install.
> >>
> >>shared_buffers = 15000
. I *thought* the MPL was one, but maybe not.
Perhaps Apache's license does. In any case I'd be very careful with any
license that comes out of FSF, since it's pretty clear what their views
on commercial software are...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROT
ers can poke at it now if the wish? It
wouldn't surprise me if right now someone is going "I wish there was
something that would let me do..."
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vca
gt;
> >
>
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cl
unning the most recent
8.0.x release and not 8.0.3. A much bigger reason is that there are
data-loss bugs that have been fixed.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.
and the owner to
> postgres?
You can do that, yes. You can also change search_path; any object not
created in a specific schema will go into the first schema listed in
search_path.
You can set a default tablespace in postgresql.conf, at the database
level, and I think at the session level as
w value
> >>>>>with no problem. When I insert directly via sql the serial column
> >>>>>updates automatically.
> >>>>> What am I missing to make this work through Delphi?
> >>>>> Bob
> >>>>
> >>>>
the stats target...
I'd wager that upping the target to 100 would eliminate a lot more
support emails than it creates.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.n
ou do not need to mention
> the software in the end user documentation. The viral aspect of the
The BSD license requires no such thing. It only requires that you
maintain the notice in the code. I challenge you to find a less
restrictive license. :)
--
Jim C. Nasby, Sr. Engineering Consultant
d to install heaps of crap into the main system, and
> instead users can choose which bits they want.
Also, some things in contrib are tied into the backend in such a way
that they're very version dependant, so it makes sense to keep them in
contrib.
--
Jim C. Nasby, Sr. Engineering Consultant
regards, tom lane
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervas
On Fri, May 19, 2006 at 02:08:01AM -0400, Tom Lane wrote:
> Don Y <[EMAIL PROTECTED]> writes:
> > Jim C. Nasby wrote:
> >> This is a very minor reason why you should be running the most recent
> >> 8.0.x release and not 8.0.3. A much bigger reason is that there
future before reporting things. :)
BTW, there's some nice performance gains to be had it 8.1.x over 8.0.x,
too.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/per
...
> sometimes the partial work worth more than partial work rolled back.
Yes, something that some people in the community have a hard time
accepting. A great example is storing session data for websites. It's
convenient to do it in the database, but it can cause big performance
proble
ich maintains a low
> perceived response time to the client) and posting to the table as fast as
> the database allows.
Uh, and just what happens when your web front-end crashes then??
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasi
thing that I
> can provide prior to that for debugging, etc, I am willing to do so. (
> If i can 'fix' it w/o re-installing it would be nice too ).
>
>
>
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensi
>
> The EXECUTE string solution did the job. Thank you very much, Martijn.
As an FYI, the function version would be faster, since it can cache the
plan. Though in this case it sounds like it doesn't matter one iota.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
P
t; projects like PostGIS or PL/R, which provide some very effective Postgres
> based power.
Yeah, I think this is a case of 'if we build it, they will come'.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork:
en up to 8.1 (8.1's
pg_dump would probably work back to 7.2 if not 7.1 or 7.0).
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-946
t;
> I tried putting vacuum inside the function, but I got an error, cannot
> run vacuum inside of function.
>
> Any thoughts?
Best bet would probably be to turn on autovacuum. Short of that, setup a
cronjob.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Perva
edit pg_hba.conf and set localhost access to
trust:
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
hostall all 127.0.0.1/32 trust
# IPv6 local connections:
hosta
is:
CHECK("start" >= '05-01-2006' AND "start" < '06-01-2006')
PostgreSQL will assume midnight, so you don't actually need the time.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software
On Mon, May 22, 2006 at 06:43:22PM -0400, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > On Wed, May 17, 2006 at 10:29:14PM -0400, Tom Lane wrote:
> >> The reason the default is currently 10 is just conservatism: it was
> >> alread
of my way.
And ditto (though I normally go for 100).
Have you ever run into problems from setting this too high?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervas
On Mon, May 22, 2006 at 02:07:50PM -0700, Joshua D. Drake wrote:
> Jim C. Nasby wrote:
> >On Thu, May 18, 2006 at 07:25:09AM +0200, Florian Weimer wrote:
> >>* Joshua D. Drake:
> >>
> >>>>>Sounds great! But why GPL? Are you looking to sell licenses?
On Tue, May 23, 2006 at 10:30:35AM +0200, Csaba Nagy wrote:
> On Tue, 2006-05-23 at 00:04, Jim C. Nasby wrote:
> > I can't imagine how bad this would be if the database actually had
> > hour-long reports that had to run... and luckily the system is quiet at
> > night w
On Tue, May 23, 2006 at 10:19:25AM +0200, Csaba Nagy wrote:
> On Mon, 2006-05-22 at 23:55, Jim C. Nasby wrote:
> > BTW, there's a bug/issue with CLUSTER that makes it not entirely
> > transaction safe.
>
> For God's sake, don't fix that one ! I rely on it...
ound this [1], but it didn't get much
traction.
[1] http://archives.postgresql.org/pgsql-general/2006-05/msg00184.php
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vc
a test case using psql. It's not very clear what you're
actually doing here...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
is the one who prevents me from working.
How fast is \d in psql? Your catalog tables might be in serious need of
vacuuming. If that's not it you'll have better luck asking for help on
the pgAdmin lists.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software
501 - 600 of 647 matches
Mail list logo
