On Wednesday, January 23, 2013 09:39:43 PM Gauthier, Dave wrote:
> Then someone who wants to look at old JAN data will have the same problem
> :-(
>
> If I recall, Oracle enables something like this. Multiple tnsfilenames (or
> something like that). There was a connect layer on the server side t
On Friday, October 25, 2013 03:53:14 AM Andreas wrote:
> Hi,
>
> I'd like to set up a DB-Server that keeps copies of our productive db
> for an external db-assistant.
> He should prepare chores on the test-server and mail the sql scripts to me.
> I'll look over those scripts and run them against t
Hello,
I am trying to setup a cluster for trac databases and want to isolate each db,
by assigning a specific user to a DB.
I followed the documentation but as shown in the following example, limiting
access by connect does not seem to be working.
What am I missing?
shridhar@bhee
Hello,
I am wondering, why following two values result in a shift by 3.5 hours. I
would expect them to be identical.
I understand that canonical time zone names could be ambiguous at times but I
think IST is not one of them.
Any explanation?
---
test=# select '2012-08-07 05:24:56.
On Tuesday 07 Aug 2012 12:21:04 AM Tom Lane wrote:
> Shridhar Daithankar writes:
> > I am wondering, why following two values result in a shift by 3.5 hours. I
> > would expect them to be identical.
> >
> > I understand that canonical time zone names could be ambiguo
Hi,
Just spotted it on LinuxToday. I don't think there would be many 8-way
configurations for opterons out there..
http://www.linuxelectrons.com/article.php/20041109100626264
Shridhar
---(end of broadcast)---
TIP 9: the planner will ignore your
On Thursday 25 Nov 2004 6:22 pm, Richard Huxton wrote:
> > On the other hand, if an application has to "fight" against the file
> > system, I would suppose it to increase RAM and CPU usage
> > significantly.
>
> It shouldn't be fighting the file system, but it does use it, and rely
> on it for cac
On Wednesday 01 Dec 2004 4:46 pm, Rodrigo Carvalhaes wrote:
> I need to find a solution for this because I am convincing customers
> that are using SQL Server, DB2 and Oracle to change to PostgreSQL but
> this customers have databases of 5GB!!! I am thinking that even with a
> better server, the re
On Wednesday 08 Dec 2004 2:42 am, Jimmie H. Apsey wrote:
> I got a server from DELL which contained a Red Hat Linux AS 3 in the box.
>
> It contained no postgresql server which I got from an earlier link,
> http://archives.postgresql.org/pgsql-admin/2003-11/msg00368.php
> When I did rpm of everythi
On Thursday 09 Dec 2004 10:37 am, JM wrote:
> Hi ALL,
>
> Im wondering sooner or later my disk will be filled-up by postgres's
> data..
>
> Can anyone give some suggestion on how to deal with this. In oracle you
> can just assign tables on a diff partition.
You could use tablespaces in post
On Friday 17 Dec 2004 3:20 pm, Marco Colombo wrote:
> Is the Oracle one _just_ that? A cron/at replacement? What about porting
> every UNIX utility to the DB engine (that would be a cross-platfrom Unix
> - wow)?
> Why don't they put web and application server functionality (apache and
> PHP) in the
On Friday 28 Jan 2005 5:06 pm, sid tow wrote:
> hi
>
> How to get the current value of a auto
> incrementing number generated using CREATE SEQUENCE
> seqname START 1
>
> Is there any way and if yes what is it. Can we run a
> select query and may be a inbuilt function which will
> return the cu
Mark Battersby wrote:
When looking at PostGres through the eyes of an Oracle Developer I was
wondering if PostGres supports a feature called Dynamic SQL. Of course
even better would be the ability to run PostGress/PL dynamically too.
Dynamic SQL and Dynamic PL/SQL are useful when you don’t know
On Friday 04 Feb 2005 7:04 pm, Ben-Nes Yonatan wrote:
First thanks for your answer David but im afraid that i still got a problem
> with this solution... im not trying to upload a big file which contain data
> which is supposed to be divided to plenty of rows, i want to upload a big
> file (wav,pp
On Monday 07 Feb 2005 6:52 pm, Shaun Clements wrote:
> Im having a problem restoring a data schema on Postgres 8.01 for Windows.
> Im using the following command
> psql -U username -d db1 > filename.dmp
Shouldn't that be
psql -U username -d db1 < filename.dmp
Shridhar
-
On Friday 11 Feb 2005 6:01 pm, Surabhi Ahuja wrote:
> does postgres support notifications.
>
> for eg. through one connection to the server, i begin a transaction and i
> do inserts there. in another sessions, i want to get notified that inserts
> are taking place in someother session. please help
On Friday 11 Feb 2005 6:07 pm, Marques Johansson wrote:
> A recent Slashdot thread on MySQL performance
> (http://developers.slashdot.org/article.pl?sid=05/02/11/038232&from=rss)
> contains a comment mentioning the following Fermilab report from May 2003:
>
> http://www-css.fnal.gov/dsg/external/fr
On Tuesday 15 Feb 2005 3:46 pm, Konstantin Danilov wrote:
> Hello, list!
> I need to view the list of tables in a database. In MySQL I can do it with
> the command "SHOW TABLES". What about PostgreSQL? Can I also see somehow
> the datatypes of tables' fields?
In psql, you can try '\dt' and '\d tab
On Tuesday 15 Feb 2005 8:03 pm, Antonios Christofides wrote:
> I'm also considering a table, of course, where each timeseries record
> will be one row. I have experimented only a little with that (id
> integer, date timestamp, value double precision, flags text, primary
> key(id, date)). It appears
C G wrote:
Dear All,
I wonder if anyone can advise me with this problem.
1. A user logs into the database (through web, webservice, some other
piece of software) - connect(user="joe",passwd="blogs")
2. We generate a random session key which will expire in 1 hour. Put
this in table (user, SessK
Hi,
I think it is time to create a pgsql-humour list where such mails can be directed..
No point wasting energy answering such questions especially when they do not
appear sincere..
Thomas Zehetbauer wrote:
Why do I have to use FOUR queries to accomplish the same result I can
get from MySQL with
Paul Ganainm wrote:
Hi all,
Following up on another thread, here is a comparison between FB and PG
from an FB'ers POV. BTW, FB is the love-child of Open-Source-Interbase.
I would love to have this comparison in a table form and posted on web. Let FB
guys chip in and make it more correct..
The
On Saturday 20 December 2003 16:44, John Sidney-Woollett wrote:
> This would be a "nice to have" for Postgres too - I believe that it
> supports PL/pgSQL, PL/Tcl, PL/Perl, and PL/Python at present.
http://techdocs.postgresql.org/guides/PLLanguages
It is already supported..:-)
Shridhar
--
On Saturday 20 December 2003 16:44, John Sidney-Woollett wrote:
> It means that you can create stored procedures/functions which reside in
> the database that are written in java (as opposed to the native SQL
> programming language).
Does it mean mysql got stored procedures? Wow..
I would like t
On Tuesday 30 December 2003 02:28, Joshua D. Drake wrote:
> >How would this differ from the existing Tutorial?
>
> Well, for one it would tell the user how to start postgresql ;)
Like this?
http://wiki.ael.be/index.php/PostgresQL101
It is linked from front page of techdocs.postgresql.org under n
On Tuesday 13 January 2004 22:13, Keith G. Murphy wrote:
> John Sidney-Woollett wrote:
> > What you could consider is one or more pools which map to the "roles"
> > that your (web) app supports. For example, if a user needs "minimal
> > rights" access to db resources, then your cgi (request handler
On Wednesday 14 January 2004 17:57, Sezai YILMAZ wrote:
> Richard Huxton wrote:
> >What are you using the count() for?
>
> I use count() for some statistics. Just to show how many records
> collected so far.
Rather than doing count(*), you should either cache the count in application
memory
or
On Wednesday 14 January 2004 18:22, Matthew Lunnon wrote:
> select logid, agentid, logbody from log where logid=300;
>
> this query also returns after about 120 seconds. The table log has about
> 7 million records, and logid is the primary key of log table. What about
> that? Why is it
On Friday 16 January 2004 16:03, Ritu Khetan wrote:
> Hello Richard,
>
>How do I switch on statement logging...?
>
>postmaster --help doesn't talk of any such switch.
Check options in postgresql.conf.
Shridhar
---(end of broadcast)---
TI
On Friday 16 January 2004 16:43, Ritu Khetan wrote:
> Hi,
>
> No such option found. There is the "S" switch for silent mode which is
> off by default anyways.
In my local installation I have following relevant options.
#log_connections = false
#log_duration = false
#log_pid = false
#log_statemen
On Saturday 17 January 2004 16:19, Leif K-Brooks wrote:
> I've been programming web applications in PHP/MySQL for a few years.
> It's worked pretty well, but I've been getting annoyed with the lack of
> more advanced features lately. After some reading, I've decided to
> switch to Perl/PostgreSQL.
On Wednesday 14 January 2004 18:09, Sezai YILMAZ wrote:
> Richard Huxton wrote:
> >PG uses MVCC to manage concurrency. A downside of this is that to verify
> > the exact number of rows in a table you have to visit them all.
> >
> >There's plenty on this in the archives, and probably the FAQ too.
>
On Wednesday 18 February 2004 13:38, Alexander Priem wrote:
> Is there a way in which I can give rights to a user for a set of
> tables/views/sequences WITHOUT having to name all of the
> table/view/sequence names?
You can use schemas. Just put everything under schema and grant user rights to
the
On Tuesday 24 February 2004 16:51, Paul Simpson wrote:
> 1) If there is a log somewhere showing failed requests, I might be able to
> see what the application is trying to do and then figure out a way around
> it.
You can log in every query server is executing. You need to enable the
correspondin
On Tuesday 24 February 2004 22:10, Paul Simpson wrote:
> Create Table TTATTASSOC (AssocId varchar(10), SetId varchar(10), SlotId
> int4)
> I have, therefore, come to the conclusion that the app requires table names
> in Upper case. How can I force this to work?
I believe postgresql is noisy about
Sezai YILMAZ wrote:
Test Hardware:
IBM Thinkpad R40
CPU: Pentium 4 Mobile 1993 Mhz (full powered)
RAM: 512 MB
OS: GNU/Linux, Fedora Core 1, kernel 2.4.24
A test program developed with libpq inserts 200.000 rows into table
logs. Insertions are made with 100 row per transaction (total 2.000
transac
On Saturday 28 February 2004 21:27, Tom Lane wrote:
> Shridhar Daithankar <[EMAIL PROTECTED]> writes:
> > Everything default except for shared_buffers=100 and effective
> > cache=25000,
>
> 100?
1000.. That was a typo..
Shridhar
-
On Tuesday 02 March 2004 19:34, Thomas Holmgren wrote:
> Hi all,
>
> I have a large number of clients synchronizing with a central database.
> The clients update their local data by polling the database for changes
> at fixed intervals. I need an efficient way of determining if data in a
> table ha
Klint Gore wrote:
In the docs it says "Plan-reading is an art that deserves an extensive
tutorial, which this is not". Is there one? I've gone beyond simple
queries (which are performing well) to the more difficult queries (which
aren't).
Try this one..
http://www.gtsm.com/oscon2003/toc.html
Daniel Fitzgerald wrote:
Hi all, I need some pointers. I want to optimize my pgsql databases
hardware-wise. I can do this in Sybase, Oracle, SQL Server, etc. by
putting let's say, indexes on one device, the trasaction logs on
another, data on another drive, etc. Can I do this in Postgresql ? I
Stijn Vanroye wrote:
Hi List,
I'm running a query on a not-so-small db. Mostly this query runs fast enough, but every once in a while the query takes a long time to complete in wich case the users start banging away on the keyboard :-).
What we would like to do is cancel the query after a certai
Stijn Vanroye wrote:
Thanks for the reply Shridhar and Tom.
But am I mistaken if setting this timeout parameter would affect all query's? That would not be the desired result. What I would like is to stop the execution of a specific (active) query if it is taking to long. If I execute the query,
Howard, Steven (US - Tulsa) wrote:
I have created a web app that stores and displays all the messages from
my database maintenance jobs that run each night. The web app uses Java
servlets and has PostgreSQL 7.0 as the back end.
When the user requests the first page, he gets a list of all the ser
Bruno BAGUETTE wrote:
Hello,
I know that the SQL norm contains some views to describes the tables (and
probably some other things) of a database.
Does PostgreSQL implement theses views (from which version number) ? I don't
find anything in the documentation about that.
You meant this?
http://www.po
On Tuesday 01 June 2004 01:35, Josué Maldonado wrote:
> Hello List,
>
> I'm importing some data from Foxpro to Postgres, there is atable wich
> contains aprox 4.8 million rows and it size about 830MB. I uploaded it
> to Postgres using dbf2pg and worked fine, it tooks about 10-15 minutes.
> Now I'm
On Tuesday 01 June 2004 15:24, Mike Mascari wrote:
> "Hewlett-Packard Co. (NYSE:HPQ - news) will support open-source
> software companies JBoss and MySQL on its servers as it seeks to
> compete with International Business Machines Corp. (NYSE:IBM - news)
> in offering Linux (news - web sites)-compa
On Tuesday 01 June 2004 21:42, Josué Maldonado wrote:
> Thanks for your responses,
>
> I did the vacuum but I cannot make the insert again at this moment, even
> when that server is not in production so all the resources should be
> dedicated to Postgres I think I still have some perfomance issues
On Wednesday 02 June 2004 02:04, BARTKO Zoltan wrote:
> I would appreciate anyone wiser than me to comment on the following:
>
> I am making an app for PostgreSQL (the server). The clients are connecting
> through the same single user. There is a model of the user organization
> inside (position hi
On Wednesday 02 June 2004 17:58, [EMAIL PROTECTED] wrote:
> > You can probably use set session authorization. Here are some brief
> > steps.
> >
> > 1. Convert all your users as postgresql database users
>
> If he's going to do this, why bother with hard-coding a single user id
> and password in th
[EMAIL PROTECTED] wrote:
Hi all;
Is it possible to write a trigger or the ilk that would disallow
direct inserts, updates, or deletes to a table unless it was
being executed through a function? How can I identify that the
DML being issued is being done via a function?
http://www.postgresql.org/
On Friday 23 Jul 2004 11:41 am, Steve wrote:
> Currently, the postgresql installation is on a single disk and so all
> the tables have their data read from a single disk. Searching on
> different tables by multiple users at the same time results in very slow
> searches, as it's mainly dependant on
On Friday 30 Jul 2004 3:56 pm, [EMAIL PROTECTED] wrote:
> Hi,
>
> In my database, I created a lot of tables before I found out about
> schemas. It's a mess!
>
> Suppose I want to get organised, and create a couple of schemas. How do
> I move existing tables into my newly created schemas?
>
> e.g.
>
On Tuesday 17 Aug 2004 6:59 pm, Eric D Nielsen wrote:
> I've been trying to setup a collaboration site, ideally I need
> forum+wiki+blog integrated functionality access control. Specificly either
> the wiki or blog need to be over viewable to members of certain groups.
>
> I'm used to phpBB for fo
On Thursday 09 Sep 2004 6:26 pm, Vic Cekvenich wrote:
> What would be performance of pgSQL text search vs MySQL vs Lucene (flat
> file) for a 2 terabyte db?
Well, it depends upon lot of factors. There are few questions to be asked
here..
- What is your hardware and OS configuration?
- What type o
On Wednesday 15 Sep 2004 6:12 pm, [EMAIL PROTECTED] wrote:
> Hi!
> I am trying to port an oracle app to postgres, an I don't know what to do
> with package scope variables.
> I was looking up some documentation and it seems (IMHO) that schemas would
> be a nice place to put the variables in(as they
On Wednesday 29 Sep 2004 1:11 pm, Devrim GUNDUZ wrote:
> Hi,
>
> We were performing some tests on PostgreSQL and found that it fails on the
> following query:
>
> SELECT 512*18014398509481984 AS result;
>
> and the result is:
>
> result
> --
> -9223372036854775808
>
>
On Wednesday 29 Sep 2004 2:25 pm, Devrim GUNDUZ wrote:
> > template1=# SELECT 512*18014398509481984::numeric(20) AS result;
> > result
> > -
> > 9223372036854775808
> > (1 row)
>
> Ok, I got the same result in 7.4.5... But... Why do we have to cast it
> into numeric? The r
On Wednesday 06 Oct 2004 12:20 pm, Glen Eustace wrote:
> I thought I had seen something that indicated that v8 was going to
> provide a means to mirror databases without needing all the triggers
> etc. I downloaded beta 3 but couldn't see anything that would do this.
>
> My goal is to mirror a data
On 23 Jun 2003 at 12:53, Kallol Nandi wrote:
>
> Is there any Postgresql client softwarefor linuxto connect to Postgresql
> database server on linux?
> Can somebody please provide me with the links or the installables if they have
> them already?
How about psql?
>
> Thanks and Regards,
> Ka
On 26 Jun 2003 at 3:44, [EMAIL PROTECTED] wrote:
> > On Thu, Jun 26, 2003 at 03:17:12AM -0400, [EMAIL PROTECTED]
> > wrote:
> >> > I have a table with 13 fields. Is that
> >> > too many fields for one table.
> >> > Mark
> >> Thirteen? No way. I've got you beat with 21:
> > Pfft! Is *that* all? I'v
On 27 Jun 2003 at 10:12, u15074 wrote:
> Can I change the size of a wal file, and if so where can I change this? I'd like
> to set the value to bigger value than 16MB.
You can not change the size but you can increase the number of WAL files used.
See postgresql.conf.
Setting it too high does no
On Wednesday 25 June 2003 21:21, Jonathan Bartlett wrote:
> My solution did not involve tablespaces, but was more of a quick solution
> to make it easier for admins to do _some_ sort of physical configuration.
>
> The idea is that the developer could do something like
>
> 'create alternate location
On Sunday 29 June 2003 15:10, Bruno BAGUETTE wrote:
> The database structure, the datas and the sequences where OK without any
> problems. He had to do a little work to add all the constraints but he's
> stucked on inserting PL/SQL packages... (Because there isn't the
> possibility to do PL/PgSQL p
On 26 Jun 2003 at 19:09, Ulisses Ponticelli Giorgi wrote:
> 1) In my SQL Server database I have about 1,000 Stored
> Procedures. In some cases, one SP calls another SP that calls another,
> and so on. To do that, I use the EXEC command. I've read that PostgreSQL
> only supports functions. Is
On Friday 04 July 2003 21:40, Jay O'Connor wrote:
> 2.varchar and int
> I was using a varchar as one field that's part of an index. Looking at the
> data, I realized I could just use an int instead. My assumption would be
> that an int would be faster to serach for thena varchar, so I converted
On 7 Jul 2003 at 12:59, Mattias Kregert wrote:
> First of all, disable FSYNC... that will speed things up a lot!
That shouldn't have been done so casually. Though can cause performance boost
and it degrades reliability of data as it can cause data corruption in case of
power/disk failure.
Bye
On 14 Jul 2003 at 5:18, Mike Mascari wrote:
> I agree. However a common scenario that has appeared on these lists is
> a request for an atomic 'CREATE IF NOT EXISTS, ELSE REPLACE' without
> race conditions. Because Oracle doesn't rollback the transaction, it
> is implementable in SQL. For PostgreS
On 14 Jul 2003 at 19:32, Peter Moscatt wrote:
> I have just installed postgresql from the RPMs on the MD dist CDs - all
> went to plan.
>
> I can manually start the server using: pg_ctl start -l -D
> /usr/local/pgsql/data.
You should place a logfile name after -l option. See if that log file get
On 16 Jul 2003 at 19:09, Kirill Ponazdyr wrote:
> It is for a advanced syslog server product we are currently developing.
>
> The very basic idea is to feed all syslog messages into a DB and allow
> easy monitoring and even correlation, we use Postgres as our DB Backend,
> in big environments the
On 18 Jul 2003 at 2:52, jerome wrote:
> is postgres capable of throwing cached results... or the right question is.. does
> postgres
> cache query results?
>
> if yes.. to both... can someone point me to a documentation that tacle this
Postgresql does not cache results. It caches data. It c
On 17 Jul 2003 at 16:47, Daniel Schuchardt wrote:
> 1.Client starts Transaction and does some changes.
> 2.Now the client notices that very huge operations are nescesarry and
> starts a procedure @ App-Server
> 3.App-Server reads the database and makes changes. Problem : the changes
> the client do
On 18 Jul 2003 at 16:58, Sean Mullen wrote:
> Other projects I've seen use their app for authentication/security
> and bypass/ignore the extremely 'useful' security system built into
> postgresql and build their own security/authentication system.
>
> I'm wondering if the reason for this is:
>
>
On 18 Jul 2003 at 16:46, Ursula Lee wrote:
> Hi all,
>
> Any idea on how to set the background color of the JPanel in Java
> Applet? A few questions here:
And how this is related to postgresql?
Bye
Shridhar
--
"All language designers are arrogant. Goes with the territory..."(By Larry
Wal
On 18 Jul 2003 at 11:35, Jordi Sánchez López wrote:
> Can two postgresql processes (running in different machines) access and
> work with the same database files in a shared storage scenario? Would
> there be any problem?
No. Don't attempt it. It will cause data corruption.
Bye
Shridhar
--
On 18 Jul 2003 at 15:58, Kallol Nandi wrote:
> How to go about scheduled backup in Postgresql.
You need to use cron and pgdump. Man pages for both of them will give you what
you want.
Bye
Shridhar
--
Cohen's Law:There is no bottom to worse.
---(end of broadcast)--
Hi,
I have a doubt regarding WAL.
Let's say I have only one wAL segment of 16MB and in a single transaction I
put 20MB of data, say a text file dump inside a transaction.
How does WAL handles this situation from POV of using/reusing WAL space and
ensuring consistency of data in table?
Does it
On 23 Jul 2003 at 12:13, Claudio Lapidus wrote:
> Hello
>
> I'd like to give a try at the new version, referred in many places as 7.4dev
> but I'm unable to find a version named this way for download. Is it the same
> as dev/postgresql-snapshot.tar.gz ? Or is somewhere already a 7.4beta?
There i
On 24 Jul 2003 at 10:00, Tom Lane wrote:
> Richard Huxton <[EMAIL PROTECTED]> writes:
> > There's a multi-year plan to "bring the code bases closer together" which
> > sounds like one of those big projects that always make me nervous.
>
> Just between us chickens, I hope they do spend multiple m
On 25 Jul 2003 at 8:45, Thomas Kellerer wrote:
> just out of curiosity: how can I find out which files in the PG_DATA directory
> belong to which database/table?
There is a contrib module oid2name. Use that.
You can just find the oid of the object from catalog and search for that file.
That's t
On 1 Aug 2003 at 9:14, Ron Johnson wrote:
> On Thu, 2003-07-31 at 23:23, Dennis Gearon wrote:
> > It will only be at a given point in time, since datasbases are by
> > design, realtime/concurrent applications.
> >
> > do:
> >
> > SELECT COUNT(*) FROM table_name;
> >
> > Should give you what you
On 1 Aug 2003 at 9:47, Ron Johnson wrote:
> On Wed, 2003-07-30 at 07:17, Robert Partyka wrote:
> > Hi,
> >
> > Have question
> >
> > How to do such like this:
> >
> > I have: select form where ;
> > how to make one column be row numbers in result?
select oid,name from a;
It's oid. Of co
On 6 Aug 2003 at 14:34, Jan Oksfeldt Jonasen wrote:
> Hi,
> I'm a very new user of the PostgreSQL database, but I've quickly
> encountered what I consider an pretty odd error. Let it be said, this is
> using the PeerDirect PostgreSQL Beta 4 using Win2K SP3, so it's bound to
> have certain issue
On 12 Aug 2003 at 11:02, Vilson farias wrote:
> Is there a way to set a "timestamp compatibility mode" for PostgreSQL
> 7.3.3's timestamp with older versions of database (like 7.1.2)? I'd like to
> set all timestamps to have precision = zero (hh:mm:ss only, without any
> millisecond).
>
> I'm as
On 15 Aug 2003 at 10:36, Ron Johnson wrote:
> In Evolution, I am able to do "Actions->Reply to List" Outlook 97
> doesn't have such a feature, but I'm sure that MozMail, Pine and Mutt
> do.
On the same topic, quite a few other lists I have sunscribed to rewrite reply
to header to list. IMO it's
On Tuesday 19 August 2003 20:54, Doug McNaught wrote:
> Doug McNaught <[EMAIL PROTECTED]> writes:
> > I have companies that force crap like this on mailing list postings...
>
> hate
>
> Arrghh.
Not to troll, but another mailing list I am on, anybody posting such
messages/footers is poli
On Tuesday 19 August 2003 21:03, Vivek Khera wrote:
> Tops on my wish list is that postgres automatically notice when a row
> is no longer needed (all transactional references to it are gone) and
> 'free' it at that time, rather then needing a special scan to
> determine the row is no longer needed
On Wednesday 20 August 2003 18:51, Vasili G. Yanov wrote:
> I have trouble: when client-program broke connection to Postgre I see
> in logs:
>
> FATAL: This connection has been terminated by the administrator.
> LOG: shutting down
>
> and I must start Postgre again. Postgre starting as:
>
>
On Wednesday 20 August 2003 19:01, Vasili G. Yanov wrote:
> >> I have trouble: when client-program broke connection to Postgre I see
> >> in logs:
> >>
> >> FATAL: This connection has been terminated by the administrator.
> >> LOG: shutting down
> >>
> >> and I must start Postgre again. Postg
On 21 Aug 2003 at 10:59, Andrew Sullivan wrote:
> On Wed, Aug 20, 2003 at 05:58:32PM -0400, Tom Lane wrote:
> > Jan Wieck <[EMAIL PROTECTED]> writes:
> > > the LRU chain but rather at it's end? This way a vacuum on a large table
> > > will not cause a complete cache eviction.
> >
> > I think wha
On 21 Aug 2003 at 11:01, Andrew Sullivan wrote:
> On Thu, Aug 21, 2003 at 03:40:29PM +1000, Martijn van Oosterhout wrote:
> > Given lazy vacuum doesn't hold locks for long periods, it could be
> > an idea to continuously spend 1% of your disk bandwidth on a
> > background vacuum. As for vacuum ful
On 21 Aug 2003 at 11:26, Andrew Sullivan wrote:
> On Thu, Aug 21, 2003 at 08:38:14PM +0530, Shridhar Daithankar wrote:
> > If a database is clean i.e. no dead tuple, an autovacuum daemon with 1 min
> > interval can achieve pretty much same result, isn't it?
>
> But we
On 22 Aug 2003 at 12:35, Claudio Lapidus wrote:
> Bruno Wolff III wote:
> > On Fri, Aug 22, 2003 at 12:17:41 +0530,
> > Shridhar Daithankar <[EMAIL PROTECTED]> wrote:
> > >
> > > Idea of autovacuum is to reduce load on vacuum full. If you set
> shared
On 28 Aug 2003 at 7:55, Chris Webster wrote:
> > Not to take anything away from the books on the topic, but my favorite
> > source is the docs that got installed with postgres
> > (/usr/local/pgsql/doc/html).
> >
> > The index isn't great, but easily overcome:
> > grep -i "search phrase" /usr/lo
On 28 Aug 2003 at 14:35, Sune Nielsen wrote:
> INSERT INTO Users (name) VALUES ('JohnDoe');
> SELECT CURRVAL('users_bid_seq');
>
> This works perfectly(!), but my project involves multiple simultanous
> users so I have to use transactions like this:
>
> BEGIN;
> INSERT INTO Users (name) VALUES ('
On 28 Aug 2003 at 8:22, Dennis Gearon wrote:
> if one gives a value for the seirial field, the trigger for the serial
> on that table doesn't generate another value?
If you are going to get sequence value first and insert it later, you can just
declare it int8 rather than serial..:-)
Would tha
On 2 Sep 2003 at 11:49, Bo Lorentsen wrote:
> > 3) Index bloat is apparently a bigger problem than I thought.
> This does not sound too nice !
That's fixed in 7.4. Vacuum in 7.4 prevents index bloat as well. Couple with
autovacuum daemon or scheduled vacuums, things (hopefully) will be lot better
On 2 Sep 2003 at 14:08, [EMAIL PROTECTED] wrote:
> Hi, where can be fount Win32 versions of Postgress?
http://techdocs.postgresql.org/guides/Windows
See, if that helps you..
Bye
Shridhar
--
No problem is insoluble.-- Dr. Janet Wallace, "The Deadly Years",
stardate 3479.4
-
On 2 Sep 2003 at 12:25, Bo Lorentsen wrote:
> On Tue, 2003-09-02 at 11:55, Shridhar Daithankar wrote:
>
> > That's fixed in 7.4. Vacuum in 7.4 prevents index bloat as well. Couple with
> > autovacuum daemon or scheduled vacuums, things (hopefully) will be lot better
On 2 Sep 2003 at 15:08, Amin Schoeib wrote:
> I would like to know if there is a Function in Postgres
> Like the LAST_DAY Function in Oracle??
> In Oracle you can use the function the get the last day of a month.
While this is not a direct answer to question..
It made me think. I am sure lot of
On 2 Sep 2003 at 9:36, Vivek Khera wrote:
> > "BL" == Bo Lorentsen <[EMAIL PROTECTED]> writes:
>
> BL> On Tue, 2003-09-02 at 04:08, Vivek Khera wrote:
> >> 3) Index bloat is apparently a bigger problem than I thought.
> BL> This does not sound too nice !
>
> No, like I said, I shaved 900Mb o
1 - 100 of 153 matches
Mail list logo
