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
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 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
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.
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
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
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 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 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 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 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
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 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
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 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 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 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 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
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 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 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 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 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 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 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 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 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
[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 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
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 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 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 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
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
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:
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,
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
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
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
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
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
-
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 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
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 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 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 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 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 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 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 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 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 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 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 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
--
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
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
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
Philippe Lang wrote:
Hello,
How can open a unix shell from a PLPGSQL function / trigger?
I would like to send an email from a postgres database, and also send some unix commands to the server, through the database...
http://archives.postgresql.org/pgsql-novice/2002-01/msg00098.php
HTH
Shridha
Patrick Hatcher wrote:
Pg: 7.4.
I thought there was supposed to be switch to allow dumping of schema X from
a database in version 7.4? But I don't see one.
Is it still not possible?
pg_dump --schema does not do it?
http://developer.postgresql.org/docs/postgres/app-pgdump.html
Shridhar
Chris Travers wrote:
HEAP tables are MySQL tables which reside in memory and are visible across
sessions. For obvious reasons, this violates the D in ACID.
Postgresql depend upon two level of buffers. One is it's own buffers and others
are OS buffer cache. So when you say update the table, the re
Chris Travers wrote:
Anyway one additional thought I had was that it should be possible to write
parsers for text files in PL/PERLu and then plug those in as views. In this
way, files such as /etc/passwd or even /var/log/messages could be used as if
they were tables in the database. Information f
Robert Treat wrote:
Yes. I think the gist of your post was "out of the box postgresql
performed like garbage compared to mysql, but then i spent some time
tweaking and tuning, taking advantage of indexes, and now it performs so
quickly that i am unable to make any changes within mysql to match
post
Socketd wrote:
Hi all
Will autovacuum both VACUUM and ANALYZE all databases, so that I can
delete my script which runs daily: "vacuumdb -a -z"?
Yes it would. One thing it never does is issuing vacuum full.
Shridhar
---(end of broadcast)---
TIP 2:
Julian North wrote:
Hi,
I am in the process of porting a number of large MSSQL databases to
Postgres.
The current id generation model in SQL server is an oracle style sequence
generator i wrote using a pretty simple stored proc and table structure.
I now need to do the same thnig in postgres.
In
Durai wrote:
Hello Sridhar,
Now, It works. Thanks lot.
But Still I have doubt:
1. How MySQL works in this case? It has any default "autocommit"?
Depends. What version of mysql you are using? If you are using mysql 3.x and/or
non-innodb tables, you don't have transactions in
Damn.. I forgot to begin the transaction..
Shridhar Daithankar wrote:
Durai wrote:
Hello Shridhar,
The script content is:
** *# cat te**stpgsql.php*
*
*
$dbconn = pg_connect("host=172.16.1.158 port=5432 dbname=test
user=postgres");
$result = pg_exec ($dbco
Durai wrote:
Hello Shridhar,
The script content is:
**
*# cat te**stpgsql.php*
*
*
$dbconn = pg_connect("host=172.16.1.158 port=5432 dbname=test
user=postgres");
$result = pg_exec ($dbconn, "update table2 set C2=C2+1;");
$result = pg_exec ($dbconn, "update table2 set C2=C2-
Durai wrote:
Hi All,
I tested "concurrent testing" in MySQL. It works fine. But I
couldn't do in PostgreSQL 7.3.4 on HPUX IPF. I got deadlock problem. I
used the PHP script to update table( one script increment the column &
another one decrement the column). Is the postgres suppo
Lada 'Ray' Lostak wrote:
You can add an attribute "work-in-progress" to your tables. Then
set up views that filter out rows with work-in-progress=true.
Your production client then needs to be modified to look at
those views instead of the tables.
I also though about this, but what about performance
Jan Wieck wrote:
Peter Eisentraut wrote:
SuSE RPMs for PostgreSQL 7.4 are available at
ftp://ftp.postgresql.org/pub/binary/v7.4/suse
or a mirror
http://www.postgresql.org/mirrors-www.html
or at
ftp://ftp.suse.com/pub/people/max/postgresql-7.4
Isn't there a "v" missing here?
Not
Uros wrote:
Hello!
I have some trouble getting good results from my query.
here is structure
stat_views
id| integer
id_zone | integer
created | timestamp
I have btree index on created and also id and there is 1633832 records in
that table
First of all I have to manualy set seq_scan
Alex wrote:
Hi,
I have a couple of functions in my database (v7.3.4) and noticed that
after a certain period of time, the functions fail to work This happened
now serveal times and the function fail at different points. The did go
away when I restarted the postmaster. At one time the function a
On Friday 14 November 2003 18:47, jini us wrote:
> I was looking at the screen shots and the screen shots
> do not show any features for GUI drag + drop
> development.
>
> Does it have a GUI drag + drop for drawing windows
> components ?
Yes. It has Qt designer which supports custom KDE widgets b
On Friday 14 November 2003 01:33, Rick Gigger wrote:
> Are there any guidelines on how often one should do a reindex?
Vacuum in 7.4 does take care of index bloat, much better than earlier
versions. So if you run autovacuum daemon with 7.4, then you can do away with
reindex.
Of course testing at
On Friday 14 November 2003 01:19, Bjørn T Johansen wrote:
> Well, I have never seen any advantages in a package system... :)
> As a developer, I like having full control of what I compile
>
>
> BTJ
>
> On Thu, 2003-11-13 at 20:45, Peter Eisentraut wrote:
> > Bjørn T Johansen writes:
> > > Just
On Tuesday 11 November 2003 02:16, Robert Creager wrote:
> When grilled further on (Mon, 10 Nov 2003 09:39:32 -0500),
>
> Tom Lane <[EMAIL PROTECTED]> confessed:
> > We recently decided we had to forbid foreign-key references from temp
> > tables to permanent tables because of this effect. I wonde
On Monday 10 November 2003 15:02, javier garcia - CEBAS wrote:
> Hello;
>
> If I add the line:
> ---
> su -c 'pg_ctl start -D /usr/local/pgsql/data/ -l
> /usr/local/pgsql/data/logfile' postgres
> ---
> to /etc/rc.d/rd.local.
> Is there a way this could work when I d
Hi all,
I hope this is useful for people using open office regularly. Can we get this
posted on techdocs?
Regards
Shridhar
Original Message
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Was fooling around a bit and managed to get OpenOffice.org 1.1 and
PostgreSQL to talk
On Tuesday 28 October 2003 14:33, Jaime Casanova wrote:
> Hi everybody, can anyone tell me if there's a way to retrieve the select
> instruction executed from the catalogs, or maybe via some structure in a
> trigger?
>
> The reason is that i have some selects constructed on-the-fly (just part of
>
Alex wrote:
Hi,
I have a test system that is setup the same as a production system and
would like to frequently copy the database over.
pg_dump takes a few hours and even sometimes hangs.
Are there any reasons not to simply just copy the entire data directory
over to the test system? I could n
Ron Johnson wrote:
On Tue, 2003-10-28 at 07:04, Shridhar Daithankar wrote:
Actually it could be a nice feature if we could access them. For certain
applications, having entire database audited is like dream come true. Of
course it has to provide timestamps/transaction ids as well but in general
On Tuesday 28 October 2003 17:13, Alex Page wrote:
> I haven't used PostgreSQL for nearly a year now, and when I was last
> using it there was some discussion on versioning control being
> introduced as a feature. Basically, for some data, I'd like to keep
> track of who changed it, when, and to wh
On Tuesday 28 October 2003 16:06, Tomas Larsson wrote:
> Hi!
>
> We're trying to call a set-returning stored procedure
> from Excel (MS Query). To do this we type:
>
> select * from getStudents()
>
> (where getStudents() is the stored procedure).
> The problem is that MS Query interprets this as if
Peter Childs wrote:
On Mon, 20 Oct 2003, Shridhar Daithankar wrote:
A fast HD with a good RAID controller. Subject to budget, SCSI are beter buy
than IDE. So does hardware SCSI RAID.
I hate asking this again. But WHY?
OK.. There are only few SCSI disks that I have handled so take it with grain
On Wednesday 22 October 2003 16:41, Birahim FALL wrote:
> Hi,
> I was an oracle dev/admin and I'm quite new to postgresql.
> Postgresql is great, but something bothers me.
> It seems that there's no concept of PACKAGE in PL/pgSQL as in Oracle
> PL/SQL.
> Is is definitely that? or did I missed somet
On Wednesday 22 October 2003 17:11, Birahim FALL wrote:
> Thanks, Shridhar,
> I've read something like that in my search this morning!
> But doing that you can have only one package in the scope of a schema.
> Then in a multipackage project these packages cannot access directly to
> the same object
On Tuesday 21 October 2003 11:26, Mark Kirkwood wrote:
> (I have not gotten around to testing random read and writes, but if
> anybody is interested I can test this and supply figures)
Can you compare ogbench results for the RAID and single IDE disks? It would be
great if you could turn off write
Vivek Khera wrote:
"S" == Stephen <[EMAIL PROTECTED]> writes:
S> The system is actually idling when I ran the tests (load average: 0.01,
S> 0.02, 0.00). When VACUUM runs, load average increases quickly (load average:
S> 1.77, 0.60, 0.21) just by running psql on command line and issuing 2
S> que
CSN wrote:
Is there any date type that can be used for 0-255
values? Like an "int1" or byte column.
You can use a smallint with constraint.
HTH
Shridhar
---(end of broadcast)---
TIP 8: explain analyze is your friend
Mat wrote:
Lines from postgresql.conf that don't start with a '#':
tcpip_socket = true
shared_buffers = 126976 #992 MB
sort_mem = 36864#36 MB
vacuum_mem = 73696 #72 MB
I would suggest scale down shared buffers to 128 or 64MB and set effective cache
size correc
[EMAIL PROTECTED] wrote:
One of my friend lost data with mysql yesterday.. The machine was taken down for
disk upgrade and mysql apperantly did not commit the last insert.. OK he was
using myisam but still..:-)
It sounds like that is more a problem with improper operating protocols
than with t
Rick Gigger wrote:
No offense taken. I am very meticulous about any software upgrades that I
do on my production systems. I'm not quite sure what you mean by "this
business since you have no idea what I am actually doing. For all you know
I am a boy scout developing a public service web site to
Richard Welty wrote:
On Wed, 8 Oct 2003 11:28:00 -0400 (EDT) John Wells <[EMAIL PROTECTED]> wrote:
It's my opinion that we should be using PG, because of the full ACID
support, and the license involved. A consultant my company hired before
bringing me in is pushing hard for MySql, citing speed
Robert Treat wrote:
Or sign up for -announce and read the weekly news, which gives a summary
of each weeks developments* and updates some other ancillary information
about the project.
That reminds me. There used to be postgresql weekly news on linuxtoday. Haven't
noticed them for quite a long.
Christopher Browne wrote:
[EMAIL PROTECTED] (Shridhar Daithankar) writes:
And I also configured a system on laclinux.com, just for curiosity. 2x
1.8GHz/4GB/36GBx2 10K RPM SCSI/Adaptec 29320 for $4800/- is damn cheap
a system. HP does not even start below $5K for 64 bit systems.
What is _most_
Ron Johnson wrote:
All that we basically need for PITR is to provide management code that
lets old WAL segments get archived off to tape (or wherever) rather than
deleted, plus some kind of control that lets the roll-forward process be
stopped at the desired point-in-time rather than necessarily ru
Christopher Browne wrote:
Oops! [EMAIL PROTECTED] (Dennis Gearon) was seen spray-painting on a wall:
Anyone got links to good db server boxes, not rackmount though?
Include any for HP, Gateway, etc.
It's the components that matter moreso than the sticker on the front
of the box.
Presently, I
Vivek Khera wrote:
SD> footprint. I dropped the table and recreated it. Also created index
SD> before loading data. The loading was slow with this approach but it
SD> finished in 3 hours. And I had an updated index as well. Just had to
SD> run vacuum over it.
I cannot believe that this was faster t
John Wells wrote:
Tom,
I'd love to, but I can't read at a terminal for longer than an hour or so.
I really prefer the dead tree version.
You can get the tarball of HTMLs out of a build and view it in lynx or something
like that if you prefer. They are very simple HTMLs.
I agree that when eyes a
1 - 100 of 153 matches
Mail list logo