On Tue, Nov 01, 2005 at 11:19:12AM -0600, Scott Marlowe wrote:
> On Tue, 2005-11-01 at 09:09, Jim C. Nasby wrote:
> > On Mon, Oct 31, 2005 at 10:13:20PM -0500, Alex Turner wrote:
> > > I didn't think query plans were cached between sessions, in which case
> > > p
loose the performance benefit of prepared statements just because odds
are good that nothing else will use it. But you still have the benefit
of bound parameters and protection from injection.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasiv
On Tue, Nov 01, 2005 at 11:31:36PM +0200, Yonatan Ben-Nes wrote:
> Jim C. Nasby wrote:
> >Yes, when you start getting into dynamically generated SQL you quickly
> >loose the performance benefit of prepared statements just because odds
> >are good that nothing else will use i
> >
>
> Runs perfectly fine on 5.4-Release AMD64 here, built straight from
> ports.
My understanding is that there is no 32 bit version of FBSD on Opterons;
as soon as buildworld sees it's on an Opteron everything goes 64 bit.
--
Jim C. Nasby, Sr. Engineering Consultant
stage
> to get good plans. Ah well, can't have everything.
Is there any reason that couldn't be added? Sounds like it might make a
good newbie TODO...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-
---(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]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcar
not nearly as bad as you'd think.
In any case, how much user demand is there for a reporting tool for
PostgreSQL? Either a seperate tool or better functionality in psql. My
guess is that this isn't something that interests most of the
developers, so the only way it's going to
an be extremely fast for
certain operations.
In any case, remember the first rule of all performance tuning: don't.
And the second rule: if you're going to, you better have metrics to
measure your tuning with to make sure it's worth it.
Feel free to call me at work if you still
On Wed, Nov 02, 2005 at 10:55:36PM +0100, MaXX wrote:
> Jim C. Nasby wrote:
> > On Wed, Nov 02, 2005 at 08:50:45PM +0100, MaXX wrote:
> [...]
> >> In simple words:
> >> Clustered indexes are like the alphabetical index in a book, where term
> >> are rand
y way
> to get this detailed lock information.
Would it be feasable to have the lock manager spew out info about lock
aquisition and release? Not only would it make getting this information
easy, but I suspect it could be a useful debugging tool.
--
Jim C. Nasby, Sr. Engineering Consultant
> Andrew Sullivan | [EMAIL PROTECTED]
> The whole tendency of modern prose is away from concreteness.
> --George Orwell
>
> ---(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an i
On Wed, Nov 02, 2005 at 06:30:38PM -0500, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > On Wed, Nov 02, 2005 at 05:59:15PM -0500, Bruce Momjian wrote:
> > > Actually, pre-8.1 used ROW EXCLUSIVE for foreign keys because we didn't
> > > have ROW SHARE until 8.1.
On Wed, Nov 02, 2005 at 07:12:36PM -0500, Tom Lane wrote:
> Bruce Momjian writes:
> > Jim C. Nasby wrote:
> >> Would it be feasable to have the lock manager spew out info about lock
> >> aquisition and release? Not only would it make getting this information
> >&g
ething? It's not a huge deal, but it would be
> useful for debugging and timings.
This seems to be something useful to have... can we get a TODO? Unless
maybe Bricklen wants to submit a patch... :)
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software htt
the referenced tables)?
>
> See the chapters on the "Information Schema" (which is an SQL standard)
> and the "system catalogs" (which are PostgreSQL specific).
See also http://pgfoundry.org/projects/newsysviews
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL P
On Thu, Nov 03, 2005 at 10:01:30AM -0600, Cristian Prieto wrote:
> Is there around any way to save a prepared plan in postgresql?
Save as in save in the database for other connections to use? It's not
very clear what you're asking...
--
Jim C. Nasby, Sr. Engineering Consultan
On Thu, Nov 03, 2005 at 04:49:33PM -0500, Andrew Sullivan wrote:
> On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote:
> > > It seems kludgey this way, though. What you really need is
> > > multimaster with conflict resolution, because you can depend on your
> But if someone decided to "fork" their own *new* project, perhaps
> starting based on one of the releases, that would an entirely
> interesting idea.
Wouldn't async multimaster make use of most all of what slony-I
currently has? ISTM that it would make life a lot easier
ld (mostly) satisfy what
you're trying to do 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
---(end of broadca
the database
has been running for a while using whatever vacuuming scheme you're
going to use (such as pg_autovacuum). That will give you a pretty good
estimate of how many pages you really need. Even that's not 100%
reliable though, so you still need to include extra space as a s
on powerpc-apple-darwin7.9.0, compiled by GCC gcc (GCC) 3.3
20030304 (Apple Computer, Inc. build 1495)
(1 row)
decibel=#
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive
the week.
>
> If we increase the max_fsm_pages, do we need to bump up the shared_buffers
> and the size of the shared memory segment of the Linux kernel(shmmax)?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby
> Sen
On Tue, Nov 08, 2005 at 10:50:53AM +0100, Zlatko Mati? wrote:
> What needs to be configured in order autovacuum process be active?
http://www.postgresql.org/docs/8.1/interactive/runtime-config-autovacuum.html
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Softw
3)='DEF'
> AND substring(col4 for 1) ='G';
>
>
> Can Postgres 8.1 use indexes to speed the queries above ?
>
> Which is the best way to to write the where clause in this case so that
> index is used ?
>
> Andrus.
>
>
>
> ------
atabase (but it is rather large).
>
> thanks,
>
> alex
>
>
>
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software
u
have to stick with the way you're representing things. There's ways to
get the same info via conventional SQL that doesn't involve building a
huge crosstab.
Something interesting is that the data structure presented here looks a
hell of a lot like a bitmap index, something new in 8.1 (we
ings like failed asserts and kill
-9'ing a backend?
--
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
---
ransaction block". Should I be doing something else, ie should I be
> explicitly rolling back once the exception is raised so I don't get
Yes.
> this error? And if so how can I "catch" the exception. Sorry for my
http://lnk.nu/postgresql.org/5sl.html
--
Jim C. Nasby, S
s.
>
>
> ---(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
eSQL installation?
Yes, there are a number of companies offering commercial support.
Pervasive (who I work for) is one; there's also Command Prompt and
others. http://www.postgresql.org/support/professional_support has a
good list of options.
--
Jim C. Nasby, Sr. Engineering Consultant
bases and RAID5 generally don't mix very well.
--
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)---
> TIP 6: explain analyze is your friend
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell:
On Tue, Nov 15, 2005 at 12:09:40AM +0100, Johnny Ljunggren wrote:
> Jim C. Nasby wrote:
> >On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote:
> >>I have three Sun Server where I have reserved on each Server a Raid-5
>
> >Keep in mind that databases an
On Tue, Nov 15, 2005 at 07:38:06PM +0100, Michelle Konzack wrote:
> Am 2005-11-14 16:54:41, schrieb Jim C. Nasby:
> > On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote:
> > > Hello *,
> > >
> > > I have three Sun Server where I have reserved on e
g yo uhave all the files, sure. Just run the installer again (make
> sure you use the same version you had before!!), set the data directory to
> the same you had before, and make sure th einstaller is set *not* to run
> initdb. It should pick it up automatically.
And to be safe make a backup
move data from one table
to another, there's probably better ways to do it.
So, what are you really trying to do?
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.comwork: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf
self-maintaining).
--
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)---
TIP 4:
y error.
Well, you could always try selecting on the child table...
What are you actually trying to do? If you just want to avoid exposing
the error you're probably better off just trapping for it in plpgsql.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasiv
as null...
>
>
> I did think about that, but I disliked the idea of two fields of nulls for
> every one full field maybe it's not as bad a way of doing it as I
> thought.
What's wrong with multiple NULL fields? It's probably the cleanest,
fastest way to do this
ows
>
> So it seems that vacuum did make anything.
>
> Andrus.
>
>
>
> ---(end of broadcast)---
> TIP 2: Don't 'kill -9' the postmaster
>
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECT
autovacuum should handle it for you.
> Must I enable statitics collection for this database ?
Well, autovacuum depends on it; see
http://www.postgresql.org/docs/8.1/interactive/maintenance.html#AUTOVACUUM
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive So
manually VACUUM ANALYZE for the whole database
> once for initial statistics colection of those tables, isn't it?
No real need to vacuum, just running analyze on the entire database
would suffice.
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software
On Thu, Sep 14, 2006 at 03:41:06AM -0700, Dhanaraj M wrote:
> Is there any utility in postgresql which can do the following?
Moving to pgsql-general, which is the appropriate list for this.
> The utility must update the table whenever there is any change in the
> text file.
> COPY command helps
On Mon, Sep 18, 2006 at 12:29:56AM +0300, Enver ALTIN wrote:
> On Fri, 2006-09-15 at 09:38 -0700, Joshua D. Drake wrote:
> > Hello,
>
> Hi Joshua,
>
> > Yeah, this is a cross post and it is slightly off topic but IMHO this is
> > important.
> >
> > Tomorrow one of our own, Devrim Gunduz is beco
I believe there's a TODO item for index-organized tables/clustered
tables. If not, there's certainly been discussion about it on the
-hackers list.
On Sun, Sep 17, 2006 at 10:21:27PM -0700, CG wrote:
> As I'm waiting for a CLUSTER operation to finish, it occurs to me that in a
> lot of cases, the
On Thu, Sep 21, 2006 at 10:48:47AM -0500, Scott Marlowe wrote:
> On Thu, 2006-09-21 at 08:47, Brad Nicholson wrote:
> > On Wed, 2006-09-20 at 16:38 -0500, Philip Hallstrom wrote:
> > > > On Wed, Sep 20, 2006 at 10:10:56AM -0500, Tony Caduto wrote:
> > > >> For a high level corp manager all they eve
On Wed, Sep 20, 2006 at 05:30:59PM -0700, CSN wrote:
> PostgreSQL doesn't have any booth babes? ;P
Berkus doesn't count??! He's got long hair! What more do you want?!
:P
> csn
>
> > On 09/20/06 16:38, Philip Hallstrom wrote:
> > [snip]
> > > I think that description is false. At a certain poi
On Fri, Sep 22, 2006 at 11:14:06AM +0200, Andrew Kelly wrote:
> On Wed, 2006-09-20 at 10:10 -0500, Tony Caduto wrote:
> > Merlin Moncure wrote:
> > > I have seen a steady progressive rise in the number of postgresql
> > > related jobs and the quality of those jobs. Major companies are
> > > appar
On Thu, Sep 28, 2006 at 01:27:24PM +0300, Adnan DURSUN wrote:
>Hi all
>
>I wanna know what is going on while a DML command works. For example
> ;
>Which commands are executed by the core when we send an "UPDATE tab
> SET col = val1..."
>in case there is a foreing k
On Thu, Sep 28, 2006 at 03:19:46PM -0700, Casey Duncan wrote:
> I have some databases that have grown significantly over time (as
> databases do). As the databases have grown, I have noticed that the
> statistics have grown less and less accurate. In particular, the
> n_distinct values have b
Patches welcome. :)
BTW, -docs or -www might be a better place to discuss this.
On Mon, Oct 02, 2006 at 05:11:20PM -0400, Brandon Aiken wrote:
> I think the problem would be partly mitigated be better or more obvious
> documentation that makes it clear that a) PostgreSQL is probably not
> configu
Moving to -general.
On Tue, Oct 10, 2006 at 04:17:06PM +0530, Ravindran G - TLS, Chennai. wrote:
> All,
>
> We are facing few issues while we install Postgres 8.0 in Windows 2000
> Japanese OS. Installer kit name : postgresql-8.0-ja
Is there a reason you're not using 8.1.4? 8.0 was the first wi
And run, do not walk, to the latest version of 7.4.x. Better yet,
upgrade to 8.1.4.
On Thu, Oct 05, 2006 at 01:04:05AM +0500, Shoaib Mir wrote:
> Run the following
>
> pg_ctl -D status
>
> to see if you have the db server running or not?
>
> As these seems to me you dont have the database serv
Please take a look at
http://www.varlena.com/GeneralBits/Tidbits/annotated_conf_e.html first.
In a nutshell, set shared_buffers to between 10% and 25% of your memory
if it's a server. And increase estimated_cache_size to something close
to how much memory you have.
On Tue, Oct 03, 2006 at 07:50:4
On Fri, Oct 06, 2006 at 05:15:55PM +0200, Thomas Poindessous wrote:
> Hello,
>
> I have a problem with my postgresql 7.4.9 server.
>
> I tried to restore a dump on the backup server (same version).
>
> I got this error :
>
> pg_restore: ERROR: date/time field value out of range: "0001-02-29
>
On Tue, Oct 10, 2006 at 06:25:21PM -0300, Jorge Godoy wrote:
> "Jacob Coby" <[EMAIL PROTECTED]> writes:
>
> > We were looking to improve our session performance, so I did a basic
> > test of using mysql 4.0 innodb vs postgres 8.1. The test did a simple
> > retrieve, update, save; 1 time per page.
On Tue, Oct 10, 2006 at 05:31:08PM -0700, Richard Broersma Jr wrote:
> My test server's sw/raid array recently died where I kept my PostgreSQL data
> directory. I have
> both a full dump of the database and a file system back-up of the data
> directory.
>
> I tried to restore my file system bac
On Thu, Oct 12, 2006 at 07:40:42PM +0200, Tim Tassonis wrote:
> > I have yet to see a good application that supports "database
> independence".
>
> If you are talking about high- end applications (big databases with lot
> of transactions), you're of course right. However, there are a lot of
> a
On Wed, Oct 11, 2006 at 11:13:21AM +0700, Luki Rustianto wrote:
> ... so what if the database size is above 20 GB, do we have to do
> pg_dump each at periodics time to get reliable backup?
No, you can also use Point In Time Recovery (PITR).
--
Jim Nasby
On Wed, Oct 11, 2006 at 01:32:29PM +0530, Ravindran G - TLS, Chennai. wrote:
> When I start PostgreSQL service, the below error message is displayed and
> finally service didn't started.
>
> The PostgreSQL Database Server 8.0 service of a local computer cannot begin.
>
>
> Error 1069: Service w
On Thu, Oct 12, 2006 at 03:31:50PM -0500, Scott Marlowe wrote:
> While all the talk of a hinting system over in hackers and perform is
> good, and I have a few queries that could live with a simple hint system
> pop up now and again, I keep thinking that a query planner that learns
> from its mista
On Thu, Oct 12, 2006 at 05:39:20PM -0500, Scott Marlowe wrote:
> > > It seems to me the first logical step would be having the ability to
> > > flip a switch and when the postmaster hits a slow query, it saves both
> > > the query that ran long, as well as the output of explain or explain
> > > ana
On Fri, Oct 13, 2006 at 11:53:15AM -0400, AgentM wrote:
> One simple first step would be to run an ANALYZE whenever a
> sequential scan is executed. Is there a reason not to do this? It
Yes. You want a seqscan on a small (couple pages) table, and ANALYZE has
a very high overhead on some platfo
The only case I can think of where view partitioning makes more sense is
if it's list partitioning where you can also drop a field from your
tables. IE: if you have 10 projects, create 10 project_xx tables where
xx is the ID of the project, UNION ALL them together in a view, and
create rules on tha
On Fri, Oct 13, 2006 at 01:52:10PM -0400, Merlin Moncure wrote:
> On 10/13/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> >Martijn van Oosterhout writes:
> >> Is that really true? In theory block n+1 could be half a revolution
> >> after block n, allowing you to commit two transactions per revolution.
On Tue, Oct 17, 2006 at 02:43:28PM -0400, Vivek Khera wrote:
>
> On Oct 17, 2006, at 2:35 PM, Steve Poe wrote:
>
> >Vivek,
> >
> >What methods of backup do you recommend for medium to large
> >databases? In our example, we have a 20GB database and it takes 2
> >hrs to load from a pg_dump file
On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote:
> Hi everybody!
> I ask you for your help on a problem I have.
> I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have
> some VERY memory intense queries, that put processor up to 40%. I see
Note that you're likely to
On Wed, Oct 18, 2006 at 04:27:21PM -0500, Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 10/18/06 16:08, Jim C. Nasby wrote:
> > On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote:
> >> Hi everybody!
> >> I ask you for y
On Wed, Oct 18, 2006 at 05:15:13PM -0400, jungmin shin wrote:
> Hello all,
>
> I read a paper, which is Query optimization in the presence of Foreign
> Functions.
> And the paper , there is a paragraph like below.
>
> In order to reduce the number of invocations, caching the results of
> invoca
And PLEASE do not post something to 3 lists; it's a lot of extra traffic
for no reason.
Moving to -hackers.
On Wed, Oct 18, 2006 at 05:15:13PM -0400, jungmin shin wrote:
> Hello all,
>
> I read a paper, which is Query optimization in the presence of Foreign
> Functions.
> And the paper , there
On Wed, Oct 18, 2006 at 05:42:22PM -0500, Ron Johnson wrote:
> > In any case, you'll be much, much happier if you do this project on at
> > least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's
> > support requirements it will probably remain supported for a few more
> > years by Tom/th
On Thu, Oct 19, 2006 at 07:51:17AM -0300, Rodrigo Sakai wrote:
> I?m developing a specialist application that needs a different kind of
> referential integrity! I need interval referential integrity where the
> bounds of the referenced interval must overlaps (or be equal) the bounds of
> the refe
On Thu, Oct 19, 2006 at 10:36:29AM -0400, AgentM wrote:
> Only if each message is contained in its own transaction since now()
> is effectively a constant throughout a transaction. In this case, I
> would choose a surrogate key since it is likely that the table will
> be referenced.
See time
On Thu, Oct 19, 2006 at 01:57:56PM +0200, Peter Bauer wrote:
In the update statement, don't wrap the ID values in quotes. At best
it's extra work; at worse it will fool the planner into not using the
index.
> shared_buffers = 1000 # min 16 or max_connections*2, 8KB each
This is *way* to
On Mon, Oct 23, 2006 at 11:19:13PM +0530, sumit kumar wrote:
> Hello ,
> does anybody help me out telling how the PostGRESQL estimates
> cardinality of LIKE operator.
Try asking on pgsql-hackers... (sorry, I don't know the answer myself).
--
Jim Nasby
On Sun, Oct 22, 2006 at 12:03:38AM +0300, Devrim GUNDUZ wrote:
> On Tue, 2006-10-17 at 14:21 +0530, Sandeep Kumar Jakkaraju wrote:
> > Can we convert from Postgres to Oracle !!???
You can also run our software and get Oracle syntax for 1/25th the cost.
--
Jim Nasby
Moving to -general (and please start a new thread instead of hijacking
an existing one).
On Thu, Nov 02, 2006 at 01:14:22PM -0500, louis gonzales wrote:
> Hello all,
> Is there an existing mechanism is postgresql that can automatically
> increment/decrement on a daily basis w/out user interaction
On Mon, Oct 30, 2006 at 10:49:33PM -0500, Ron Peterson wrote:
> I created a set of PostgreSQL functions which implement the extended set
> of digest/hashing functions provided by the Mhash library
> (http://mhash.sourceforge.net/).
>
> For anyone interested, the code is available here:
>
> http:/
On Thu, Nov 09, 2006 at 08:54:20AM -0500, Rick Schumeyer wrote:
> To date I have always used pg on a system where I had pg superuser status.
> I'm trying to move a database from such a system to one where I am just
> a user, and I'm having a couple of problems.
>
> The first is, the output of pg_
On Thu, Nov 09, 2006 at 04:37:23PM +0100, Alban Hertroys wrote:
> 'lo list,
>
> I have a plpgsql SP where I loop through a cursor. I have an internal
> variable that keeps the previous row, so that I can compare it with the
> current row in the cursor.
> Like so;
>
> DECLARE
> current table
You want to do count(DISTINCT part_id) and count(DISTINCT desc).
On Sat, Nov 11, 2006 at 04:25:51PM -0800, Kojak wrote:
> Here's a description of the scenario. The question I'm asking follows
> the description.
> 3 tables
> table1:
> job_no int4
> rate1 float4
> qty1 float4
> rate2 float4
> qty2
On Tue, Nov 14, 2006 at 06:08:44AM -0800, [EMAIL PROTECTED] wrote:
> Good morning,
>
> I've recently just inherited a PostgreSQL database that is a back end
> for some logistics software we use here. We have our own Oracle
> servers in our group on faster machines with automated backup so we
> wo
On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
> I have an 8.1.2 autovac which appears to be hanging/blocking
> every few days or so, but we're don't understand what's causing
> it. I wasn't able to catch a backtrace before we killed it. I
> do not see autovac locks in the pg_locks vie
On Tue, Nov 14, 2006 at 01:31:28PM -0500, Carlson, James (Jim) wrote:
> I have an old server that is still working faithfully. It is running Red
> Hat 7.2 and Postgersql 7.2. In anticipation of the day it will die, that
> I am concerned is closer than I want it to be, I have set up a shinny
> new s
On Tue, Nov 14, 2006 at 12:53:56PM -0700, Ed L. wrote:
> On Tuesday November 14 2006 12:49 pm, Jim C. Nasby wrote:
> > On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
> > > I have an 8.1.2 autovac which appears to be hanging/blocking
> > > every few days or so,
On Thu, Jan 11, 2007 at 03:14:37PM -0500, Tom Lane wrote:
> The downside of this is that a real EACCES problem wouldn't get noted at
> any level higher than LOG, and so you could theoretically lose data
> without much warning. But I'm not seeing anything else we could do
> about it --- AFAIK we ha
On Thu, Jan 11, 2007 at 04:32:42PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > Given that this could result in data loss, if this was to be done I'd
> > very much want to see a way to disable it in a production environment.
>
>
On Thu, Jan 11, 2007 at 06:04:56PM -0500, Andrew Dunstan wrote:
> Please don't. At least not on the PostgreSQL web site nor in the docs.
> And no, I don't run my production servers on Windows either.
>
> For good or ill, we made a decision years ago to do a proper Windows
> port. I think that it
On Sun, Jan 21, 2007 at 11:39:45AM +, Heikki Linnakangas wrote:
> Russell Smith wrote:
> >Strange idea that I haven't researched, Given Vacuum can't be run in a
> >transaction, it is possible at a certain point to quit the current
> >transaction and start another one. There has been much ch
On Sat, Jan 20, 2007 at 11:19:50AM -0600, Kelly Burkhart wrote:
> On 1/20/07, Shoaib Mir <[EMAIL PROTECTED]> wrote:
> >Should help --> ALTER TABLE tablename ALTER columname TYPE text;
>
> I was looking for a way to alter a column from varchar(n) to text
> without using the alter command and conseq
On Sun, Jan 21, 2007 at 06:55:56AM -0800, brian stone wrote:
> Are there any built in tools or 3rd party tools for distributing a postgresql
> database? I need an active active configuration; master-master with fail
> over. The project I am working needs to support a very large number of
> tra
On Sun, Jan 21, 2007 at 12:27:41PM -0500, Jaime Casanova wrote:
> On 1/21/07, mbneto <[EMAIL PROTECTED]> wrote:
> >Hi,
> >
> >I have a dumpall file generated from a 8.0 version that I need to import
> >back to a 7.4 server.
> >
> >Is there a way to do that?
> >
> >a psql -f db.out template1 gives m
On Tue, Jan 23, 2007 at 07:47:26AM -0800, Subramaniam Aiylam wrote:
> Hello all,
>
> I have a setup in which four client machines access
> a Postgres database (8.1.1) running on a Linux box.
> So, there are connections from each machine to the
> database; hence, the Linux box has about 2 postgre
On Fri, Feb 23, 2007 at 01:49:06PM +1300, Andrej Ricnik-Bay wrote:
> On 2/23/07, Jim Nasby <[EMAIL PROTECTED]> wrote:
> >That depends greatly on what you're doing with it. Generally, as soon
> >as you start throwing a multi-user workload at it, MySQL stops
> >scaling. http://tweakers.net recently d
On Fri, Feb 23, 2007 at 01:25:25PM +, Dave Page wrote:
> Given the recent discussions of applications stacks, PHP & Ruby etc. it
> seems an ideal time for me to introduce a project I've been working on.
>
> StackBuilder is an extension of the Windows installer for PostgreSQL
> that will allow
On Fri, Feb 23, 2007 at 04:08:45PM -0300, Alvaro Herrera wrote:
> Mark Stosberg wrote:
> > I just tried to add something to the pg_autovacuum table for the first
> > time today (with 8.1). I wanted to make the simplest possible entry:
> > Disable auto-vacuuming for a table. However, the data model
ike schedulers.
Actually, I believe part of the discussion also involved how to handle
long-running workloads that you don't want to monopolize the machine.
--
Jim C. Nasby, Database Architect[EMAIL PROTECTED]
Give your computer some brain candy! www.distributed.net Team #182
On Fri, Feb 23, 2007 at 06:47:52PM -0500, Tom Lane wrote:
> I wrote:
> > I don't find this particularly important, because we have never intended
> > direct update of catalog entries to be a primary way of interacting with
> > the system. The current pg_autovacuum setup is a stopgap until the dust
On Tue, Feb 27, 2007 at 11:26:02AM -0800, Dhaval Shah wrote:
> I am planning to use 8.2 and the average inserts/deletes and updates
> across all tables is moderate. That is, it is a moderate sized
> database with moderate usage of tables.
>
> Given that, how often do I need to reindex the tables?
On Tue, Feb 27, 2007 at 06:43:51PM -0600, John Jawed wrote:
> Is there any difference as far as when the "uniqueness" of values is
> checked in DML between a unique index vs a unique constraint? Or is
> the only difference syntax between unique indices and constraints in
> PostgreSQL?
Syntax only,
201 - 300 of 647 matches
Mail list logo
