On Fri, 3 Oct 2003, scott.marlowe wrote:
> On Fri, 3 Oct 2003, Tom Lane wrote:
> >
> > It'd be interesting to think about whether a write-caching IDE drive
> > could safely be used for data storage, if WAL is elsewhere.
>
> Well, I just so happen to have a machine with two drives in it. I'll ge
I did a vacuum and got the same result.
I think the problem lies in there is swapping going for groupby when there is a
large number of rows in the table, 5000 in this case.
I guess I have to use group by with caution.
thanks for the all the replies though,
kathy
> Date: Fri, 03 Oct 2003 15:53:
On Fri, 3 Oct 2003, Kathy Zhu wrote:
> Hi,
>
> I notices a weird thing here.
>
> version 7.2.1
> on Solaris
>
> table "test", has a field "state".
> There are 4 "state" values, 1, 2, 3, 4.
>
> select count(*) from test group by state;
> took 11500 msec
>
> but
>
> select count(*) from test w
Hi,
I notices a weird thing here.
version 7.2.1
on Solaris
table "test", has a field "state".
There are 4 "state" values, 1, 2, 3, 4.
select count(*) from test group by state;
took 11500 msec
but
select count(*) from test where state = 1;
select count(*) from test where state = 2;
select coun
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> Yes, you are. Basically, with fsync on, things have to happen in order.
> I.e.
> write to WAL what you're gonna do. WAIT for confirmation on write
> write the tuples out. wait for confirmation
> checkpoint the WAL. wait for confirmation
Not really.
On Fri, 3 Oct 2003, Relaxin wrote:
> Does this have native Win32 support?
As has been mentioned *several* times already, v7.4 will *not* have Win32
support in it.
>
> ""Marc G. Fournier"" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> >
> > Well folks, we are now coming into
> "sm" == scott marlowe writes:
sm> also, turning off fsync during the load helps a lot. Be sure to turn it
sm> back on when you're done of course.
Only if you don't have a battery-backed cache on your RAID. If you
do, it won't likely make a big difference. For me it was about 2
seconds
On Fri, 3 Oct 2003, Alvaro Herrera wrote:
> On Fri, Oct 03, 2003 at 01:06:26PM -0600, scott.marlowe wrote:
>
> > also, turning off fsync during the load helps a lot. Be sure to turn it
> > back on when you're done of course.
>
> I'm not sure I understand why this is so. If I turn fsync off, i
Native Win32 is slated for 7.5.
Sincerely,
Joshua Drake
Relaxin wrote:
Does this have native Win32 support?
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - [EMAIL PROTECTED] - htt
On Fri, 3 Oct 2003, Vivek Khera wrote:
> > "sm" == scott marlowe writes:
>
> sm> also, turning off fsync during the load helps a lot. Be sure to turn it
> sm> back on when you're done of course.
>
> Only if you don't have a battery-backed cache on your RAID. If you
> do, it won't likely
Tom Lane writes:
> Building the HTML version is pretty simple, but it does look like
> making a nice printed version is tedious ... which, no doubt, is
> why no one does it for beta releases.
For printable versions, the size and complexity of the PostgreSQL
documentation breaks every tool known t
On Fri, 3 Oct 2003, Kathy Zhu wrote:
> Hi,
>
> I notices a weird thing here.
>
> version 7.2.1
> on Solaris
>
> table "test", has a field "state".
> There are 4 "state" values, 1, 2, 3, 4.
>
> select count(*) from test group by state;
> took 11500 msec
>
> but
>
> select count(*) from test where
On Fri, Oct 03, 2003 at 11:27:11 -0400,
Gene Vital <[EMAIL PROTECTED]> wrote:
> Hi all.
> I am using Visual FoxPro via ODBC to update records on a 7.3.4
> PostgreSql server and it appears that it always uses delete/insert
> instead of updating the current record. Can this be changed to upda
On Tuesday 30 September 2003 09:15 pm, Greg wrote:
> I also have troubles with pg_dump. I have a database called 'shipping' and
> it has many tables(I populated them via a script). To dump the database I
> did these steps:
>
> su greg and then pg_dump > /tmp/greg.dmp. A file greg.dmp gets created b
Hi all.
I am using Visual FoxPro via ODBC to update records on a 7.3.4
PostgreSql server and it appears that it always uses delete/insert
instead of updating the current record. Can this be changed to update
the existing record instead?
--
Eugene Vital
Any technology indistinguishable from m
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
"Robert Wille" <[EMAIL PROTECTED]> writes:
>> You probably still have LC_ALL set to something else. LC_ALL overrides
>> LC_COLLATE and friends, which in turn override LANG.
> Nope. Any other ideas?
Please use pg_controldata to verify the LC_ settings on both databases.
I suspect they are not rea
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> On Fri, Oct 03, 2003 at 10:08:43 -0400,
> John Wells <[EMAIL PROTECTED]> wrote:
>> Does anyone provide printed copies of the documentation for a fee? I know
>> some companies do this for other apps...
> You should be able to print the documentation
I also have troubles with pg_dump. I have a database called 'shipping' and
it has many tables(I populated them via a script). To dump the database I
did these steps:
su greg and then pg_dump > /tmp/greg.dmp. A file greg.dmp gets created but
it has nothing in it(0 bytes). Could you advise what was
Hi, I'm in the process of converting an Oracle database into
postgresql. One thing I've noticed is that postgresql functions keep
the entire function body in a string, e.g.:
CREATE OR REPLACE FUNCTION f_do_something(varchar, numeric, varchar)
RETURNS varchar AS
'
...
'
LANGUAGE 'plpgsql' VOLAT
[EMAIL PROTECTED] ("John Wells") writes:
> To that end, I've also started studying up on Postgresql. It seems to
> have all the necessary features for a transaction heavy DB. The recent
> release is 7.3. Of course, "the proof will be in the pudding." We
> average 2.5 million transactions per da
Hi
the problem is to avoid users from viewing functions code (in general db
structures) when connecting to db by means of pgpadmin client.
My db contains several tables and functions and I need to make users viewing
only a restricted
number of tables. It works for tables, as it's possible to define
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 have a Dell 6600 PowerE
Hmm,
it's weird. Could you provide us with backtrace ?
Oleg
On Tue, 30 Sep 2003 [EMAIL PROTECTED] wrote:
> After applying the patches supplied so far and also trying the lastest
> stable tar.gz for tsearch2 ( downloaded 24th of september)
>
> I am still experiencing the same issue as pr
On Fri, 3 Oct 2003, Bruno BAGUETTE wrote:
> I'm getting many errors when I do the make on the patched files. Is
> there other people that have compiled successfully the patched
> mod_auth_pgsql 2.0.1 ?
>
> I've attached to this email the error log. Do you have the same errors
> than me or do I h
I need to find out which tables, and columns in that table, reference a
given table.
I would like to use the information_schema views, but am stuck at 7.3.X
right now.
Here is what I came up with so far
SELECT pcl.relname AS thistable,
pcl1.relname AS referencesthistable
FROM ((pg_constraint
I am running a SELECT to get all tuples within a given date range. This
query is much slwoer than i expected - am i missing something?
I have a table 'meta' with a column 'in_date' of type timestamp(0), i
am trying to select all
records within a given date range. I have an index on 'in_date' and
On Thursday 02 Oct 2003 09:13 in
<[EMAIL PROTECTED]>, Chris
([EMAIL PROTECTED]) wrote:
> Suppose you want to use an RDBMS to store messages for a threaded
> message forum like usenet and then display the messages. A toy table
> definition (that I've tried to make standards compliant) might look
>
Hello
I have a problem, I want to migrate the data of a postgres' database to a
mysql's database, this because i need to move to a windows.
I tried making a postgres' backup using pg_dump, but this file doesn't have
the insert in Transac-sql.
Any help is welcome
txs in advance!!
-
[I also posted this to comp.databases but since I'm actually using
PostgreSQL I would be content with a pgsql specific answer, so I
also posted this to comp.databases.postgresql.novice because I'm
a novice and it looked like a good group, but then I realized that
this might not be a novice question
Sorry about the repost here guys... I sent this from my other email
(non-subscribed), but sent an email to the list admin before reposting to
get him/her to cancel it. Apparently some miscommunication there. :)
---(end of broadcast)---
TIP 7: don't
> Yes, the mod_auth_pgsql series for Apache 2 is broken as you
> describe. It does not release the connection, but the change
> is intentional. Looking at the Changelog I see:
>
> - now we reuse database connection, 2x speedup !!
>
> Perhaps this is a good thing with different MPMs, but the
--- Fabrizio Mazzoni <[EMAIL PROTECTED]> wrote:
> Hello .. i did the migration and my advice is that
> you forget about the automatic translation tools...
I have used the "migration wizard" that comes as a
plugin for PgAdminII, and was very happy with the
result. Yes, you can do everything by h
After applying the patches supplied so far and also trying the lastest
stable tar.gz for tsearch2 ( downloaded 24th of september)
I am still experiencing the same issue as previously described:
I try to do a
SELECT to_tsvector( 'default', 'some text' )
The backend crashes.
SELECT to_tsvector(
Anyone on the list have experience with this? I (potentially) could be
hired today to help in an effort to convert from Progress to Postgresql,
and I'm looking for any resources/insights/urls/books/etc that might aid
towards this end.
Anything you can forward will be greatly appreciated (and paid
Hi,
this might be actually offtopic, but its always time to fight some FUD :-)
> Microsoft will be doing away with the OLEDB to ODBC bridge in the near
> future.
Funny enough if I use __Microsoft__ SQL Query Analyzer which directly
connects to SQL Server and somehow shut the SQL Server down whi
"Marcelo Soares" <[EMAIL PROTECTED]> writes:
> To me, this looks not like a bug, because the tuple is not at A phisically.
A lot of people call it a bug because it makes it impossible for them to
use inheritance the way they want to.
> Like I said, this is not a problem for me, but I want to know
Shridhar Daithankar <[EMAIL PROTECTED]> writes:
> Peter Childs wrote:
>>> Postgresql do have update logs in form of WAL.
>> No it does not. WAL is Down-Date Logs not update logs. WAL will
>> enable you to rewind to the beginning of all currently running
>> transactions after a crash. Ie roll-bac
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
> "SD" == Shridhar Daithankar <[EMAIL PROTECTED]> writes:
SD> You can try creating index/triggers first and load the data. At the
SD> end it will take a while before you get a usable database with either
SD> approach but see what works faster for you.
The triggers and FK's don't do much at th
On Fri, Oct 03, 2003 at 10:08:43 -0400,
John Wells <[EMAIL PROTECTED]> 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.
>
> Does anyone provide printed copies of the documentation for a fee? I know
> some com
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
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.
Does anyone provide printed copies of the documentation for a fee? I know
some companies do this for other apps...
Thanks,
John
Tom Lane said:
> "John Wells" <[EMAIL PROTECT
Well folks, we are now coming into the home stretch of another long
development cycle, and its time for more vigorous and extensive testing
...
Last night, we bundled up Beta4, which is the first one that we've
officially announced "publicly", with the other 3 having been only
announced on -hacke
"John Wells" <[EMAIL PROTECTED]> writes:
> Are there any books out there that are fairly current, but go into the
> more advanced aspects of Postgresql, such as internals and advanced
> programming? I'd rather avoid the whole intro to SQL with a few extra
> chapters on Postgresql if I could help i
> Robert Wille writes:
>
> > I have tried to do the same on my production server, and when I do the
> > initdb, it says that LC_COLLATE is C, but it does not sort the same as
> > the test server. Namely, on the test server 'z' < '~' and on the
> > production server 'z' > '~'.
>
> You probably sti
Are there any books out there that are fairly current, but go into the
more advanced aspects of Postgresql, such as internals and advanced
programming? I'd rather avoid the whole intro to SQL with a few extra
chapters on Postgresql if I could help it.
Thanks,
John
---(
47 matches
Mail list logo
