Does Postgresql 8.1 support Full Text Search?
If yes, please provide the link about documentation.
On Mon, Feb 22, 2010 at 02:47:00PM +0600, AI Rumman wrote:
> Does Postgresql 8.1 support Full Text Search?
> If yes, please provide the link about documentation.
It's available as an add-on, but since 8.1 is so close to its end of
life, consider moving to 8.4 first, or if the project is out past Q
I have a plan to upgrade database, but right now I have to use text search
indexing for performance improvement.
Following is the rpm status of my server:
[r...@vcrmdev01 ~]# rpm -qa|grep postgres
postgresql-8.1.11-1.el5_1.1
postgresql-python-8.1.11-1.el5_1.1
postgresql-server-8.1.11-1.el5_1.1
po
Hello everyone,
my company has been using pg_standby as a replication solution for a
while and it has been working great for our needs. Unfortunately, about
once a month we get the following error on the standby bases:
vacuumdb: vacuuming of database "" failed: ERROR: could not access
status
Hi,
Could anyone please tell me what is unsecure postgres languages(like C,
pgperl, pgpython??). How to disable them or restrict them only for super
user?
Thanks,
Dipti
Helo
I am working on spring project with postgres 8.4
i wrote a function in postgrees which i am passing the argument email
email[] array
>From front end we need to insesrt data into that emailarray .so i used
java.arraylist.util
while i am running i got the following error Please help me
err
Hello All,
I have been writing a function with SECURITY DEFINER enabled. Basically, I
am looking for ways to override the users SET option settings while
executing my function to prevent the permissions breach. For example, to
override "SET search_path", I am setting search path in my function bef
Helo
I am working on spring project with postgres 8.4
i wrote a function in postgrees which i am passing the argument email
email[] array
>From front end we need to insesrt data into that emailarray .so i used
java.arraylist.util
while i am running i got the following error Please help me
err
Hello
you can overwrite standard settings only for function
CREATE [ OR REPLACE ] FUNCTION
name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = }
default_expr ] [, ...] ] )
[ RETURNS rettype
| RETURNS TABLE ( column_name column_type [, ...] ) ]
{ LANGUAGE lang_name
| WINDO
Hi,
Am 22.02.2010 11:56, schrieb dipti shah:
Hi,
Could anyone please tell me what is unsecure postgres languages(like C,
pgperl, pgpython??). How to disable them or restrict them only for super
user?
They are already restricted for the super user because of their
"insecure" nature. That means
When I am using the query:
select length(description), to_tsvector('default',description) as c from
crmentity ;
Getting error:
NOTICE: word is too long
Postgresql 8.1.
Could anyone please tell me why?
On Sun, Feb 21, 2010 at 10:32 PM, Merlin Moncure wrote:
> On Sun, Feb 21, 2010 at 9:22 PM, Tom Lane wrote:
>> Merlin Moncure writes:
>>> On Sat, Feb 20, 2010 at 9:38 PM, Petr Chmelar wrote:
Is there a way how to listen and trigger the notify messages in the
database (+-)immediately an
Hi,
while passing util list to Postgres stored procedure getting an exception
saying
*org.postgresql.util.PSQLException: Cannot cast an instance of
java.util.ArrayList to type Types.ARRAY*
can you help to resolve it? its urgent
Method in Dao
public void savePerson(Person person, List addresses,
Hello all, I get the following error message when ecpg precompiles an EXEC SQL
INCLUDE on this variable:
short cst_vent[MAX_SUC][12]; (MAX_SUC is defined as 24)
Mesage:
"No multidimensional array support for simple data types"
Is there a fix or am I stuck?
Version: PostgreSQL 8.
mike stanton írta:
> Hello all, I get the following error message when ecpg precompiles an
> EXEC SQL INCLUDE on this variable:
>
> short cst_vent[MAX_SUC][12]; (MAX_SUC is defined as 24)
>
> Mesage:
>
> "No multidimensional array support for simple data types"
>
> Is there a fix
Jignesh Shah wrote:
> I have been writing a function with SECURITY DEFINER enabled.
> Basically, I am looking for ways to override the users SET
> option settings while executing my function to prevent the
> permissions breach. For example, to override "SET
> search_path", I am setting search p
dipti shah wrote:
> Could anyone please tell me what is unsecure postgres
> languages(like C, pgperl, pgpython??). How to disable them or
> restrict them only for super user?
I have never heard of "unsecure" languages - what exactly do you mean?
If you mean "untrusted" languages like PL/PerlU,
AI Rumman wrote:
> I have a plan to upgrade database, but right now I have to
> use text search indexing for performance improvement.
>
> Following is the rpm status of my server:
>
> [r...@vcrmdev01 ~]# rpm -qa|grep postgres
> postgresql-8.1.11-1.el5_1.1
> postgresql-python-8.1.11-1.el5_1.1
>
AI Rumman wrote:
> When I am using the query:
>
> select length(description),
> to_tsvector('default',description) as c from crmentity ;
>
> Getting error:
>
> NOTICE: word is too long
>
> Postgresql 8.1.
>
> Could anyone please tell me why?
Because there is a "word" in the "descriptio
On Mon, Feb 22, 2010 at 2:10 PM, beulah prasanthi wrote:
> Helo
> I am working on spring project with postgres 8.4
> i wrote a function in postgrees which i am passing the argument email
> email[] array
> From front end we need to insesrt data into that emailarray .so i used
> java.arraylist.
Hi, I have the given tables and query, but I'm confused why the cost
of the query is so high. I've left it running over night. By
comparison, a "select * from metarelcloud_transactionlog order by
transactionid" takes on the order of seconds/minutes (at least in
MySQL). As far as I can tell, the com
Yang Zhang writes:
> Hi, I have the given tables and query, but I'm confused why the cost
> of the query is so high.
The reason the estimated cost is so high is that the estimated number of
rows out of the join is enormous. It's going to take awhile. One
question worth asking is what you've got
Based on your suggestions, I have applied the attached patch to mention
_not_ to use pg_dump or pg_dumpall in two places, and to briefly explain
why. Thanks.
---
Craig Ringer wrote:
> On Mon, 2009-10-19 at 07:18 -0700, Mite
On Mon, 22 Feb 2010, beulah prasanthi wrote:
Helo
I am working on spring project with postgres 8.4
i wrote a function in postgrees which i am passing the argument email
email[] array
From front end we need to insesrt data into that emailarray .so i used
java.arraylist.util
while i am runn
Sorry Albe for confusion. Yes, I meant untrusted languages like C, PL/PerlU,
PL/PythonU etc...
Thanks a lot you and Tino for nice reply. Could you guys tell me how could I
verify whether those languages are installed on my PostGreSQL server?
Thanks for being there,
Dipti
On Mon, Feb 22, 2010 at
Kris Jurka wrote:
> You need to pass an instance of java.sql.Array, not a Collection
> or something else that is array like.
Ah, right. After extracting an array from the java.util.ArrayList,
it needs to be turned into a java.sql.Array using the
Connection.createArrayOf method.
Most definit
On Mon, Feb 22, 2010 at 12:10 PM, Tom Lane wrote:
>> I've left it running over night. By
>> comparison, a "select * from metarelcloud_transactionlog order by
>> transactionid" takes on the order of seconds/minutes (at least in
>> MySQL).
>
> That's got approximately nothing to do with this query.
Thanks a ton Laurenz and Pavel for your responses but I really didn't follow
you. I am not master in PostGreSQL yet. Could you please give me some
example?
Basically, I want to know how many such SET options I should reset before
executing my function and at the end it should also be restored to o
dipti shah wrote:
Sorry Albe for confusion. Yes, I meant untrusted languages like C,
PL/PerlU, PL/PythonU etc...
Thanks a lot you and Tino for nice reply. Could you guys tell me how
could I verify whether those languages are installed on my PostGreSQL
server?
Thanks for being there,
Dipti
I have the exact same table of data in both MySQL and Postgresql. In Postgresql:
tpcc=# \d metarelcloud_transactionlog
Table
"public.metarelcloud_transactionlog"
Column| Type |
Modifiers
-+---
2010/2/22 Jignesh Shah :
> Thanks a ton Laurenz and Pavel for your responses but I really didn't follow
> you. I am not master in PostGreSQL yet. Could you please give me some
> example?
>
> Basically, I want to know how many such SET options I should reset before
> executing my function and at the
Hi,
I have just noticed that "SET ROLE" doesn't work from security definer
function. I don;t know why but it clearly gives the error that SET role
doesn;t work in security definer context.
Basically, I am trying to write a store procedure which creates a table
asked by user along with other assoc
hello
the speed depends on setting of working_memory. Try to increase a working_memory
set working_memory to '10MB';
Regards
Pavel Stehule
2010/2/22 Yang Zhang :
> I have the exact same table of data in both MySQL and Postgresql. In
> Postgresql:
>
> tpcc=# \d metarelcloud_transactionlog
>
I'm new to postgres and am trying to display rows in a table that are have a
value between 2 fields.
The rows I want to display should be selected by the grademin or grademax
fields. I'd like to display the rows in sections that are labeled Grades
3-5, 6-8, and 9-12.
The problem that I am havin
There is no index on the column transactionid in your PostgreSQL-
table, as there is in your MySQL-table. This explains the difference.
CREATE INDEX i_transactionid ON public.metarelcloud_transactionlog
(transactionid);
Op 22 feb 2010, om 19:10 heeft Yang Zhang het volgende geschreven:
I h
On 22/02/2010 18:14, flashbangpop wrote:
> I'm new to postgres and am trying to display rows in a table that are have a
> value between 2 fields.
>
> The rows I want to display should be selected by the grademin or grademax
> fields. I'd like to display the rows in sections that are labeled Grad
On Mon, Feb 22, 2010 at 10:17 AM, Frank Heikens wrote:
> There is no index on the column transactionid in your PostgreSQL-table, as
> there is in your MySQL-table. This explains the difference.
>
> CREATE INDEX i_transactionid ON public.metarelcloud_transactionlog
> (transactionid);
Does an inde
On Mon, Feb 22, 2010 at 1:13 PM, Pavel Stehule wrote:
> hello
>
> the speed depends on setting of working_memory. Try to increase a
> working_memory
>
> set working_memory to '10MB';
It's already at
tpcc=# show work_mem;
work_mem
--
2kB
(1 row)
I also wouldn't have imagined an ex
On Mon, Feb 22, 2010 at 1:30 PM, Richard Broersma
wrote:
> On Mon, Feb 22, 2010 at 10:17 AM, Frank Heikens wrote:
>
>> There is no index on the column transactionid in your PostgreSQL-table, as
>> there is in your MySQL-table. This explains the difference.
>>
>> CREATE INDEX i_transactionid ON pu
>> set work_mem to '1MB'
>> set search_path = 'public';
Thanks for the example Pavel. I understood it. Are there any other SET
options except above that I need to set to prevent security breach?
Thanks,
Jack
On Mon, Feb 22, 2010 at 11:41 PM, Pavel Stehule wrote:
> 2010/2/22 Jignesh Shah :
> > T
2010/2/22 Jignesh Shah :
>>> set work_mem to '1MB'
>>> set search_path = 'public';
>
> Thanks for the example Pavel. I understood it. Are there any other SET
> options except above that I need to set to prevent security breach?
>
I am not sure - I know only search_path
Pavel
> Thanks,
> Jack
>
>
Op 22 feb 2010, om 19:30 heeft Richard Broersma het volgende geschreven:
On Mon, Feb 22, 2010 at 10:17 AM, Frank Heikens
wrote:
There is no index on the column transactionid in your PostgreSQL-
table, as
there is in your MySQL-table. This explains the difference.
CREATE INDEX i_transacti
On 22 Feb 2010, at 19:35, Yang Zhang wrote:
> I also wouldn't have imagined an external merge-sort as being very
Where's that external merge-sort coming from? Can you show an explain analyze?
If your work-mem is too low there's a good chance that Postgres has to use your
disks for sorting, whi
Yang Zhang escribió:
> I'm running:
>
> select * from metarelcloud_transactionlog order by transactionid;
>
> It takes MySQL 6 minutes, but Postgresql is still running after 70
> minutes. Is there something like a glaring misconfiguration that I'm
> overlooking? Thanks in advance.
How large i
On Mon, Feb 22, 2010 at 1:48 PM, Alban Hertroys
wrote:
> On 22 Feb 2010, at 19:35, Yang Zhang wrote:
>
>> I also wouldn't have imagined an external merge-sort as being very
>
>
> Where's that external merge-sort coming from? Can you show an explain analyze?
I just assumed that the "Sort" in the E
On Mon, Feb 22, 2010 at 2:03 PM, Alvaro Herrera
wrote:
> Yang Zhang escribió:
>
>> I'm running:
>>
>> select * from metarelcloud_transactionlog order by transactionid;
>>
>> It takes MySQL 6 minutes, but Postgresql is still running after 70
>> minutes. Is there something like a glaring misconfig
Op 22 feb 2010, om 20:07 heeft Yang Zhang het volgende geschreven:
On Mon, Feb 22, 2010 at 1:48 PM, Alban Hertroys
wrote:
On 22 Feb 2010, at 19:35, Yang Zhang wrote:
I also wouldn't have imagined an external merge-sort as being very
Where's that external merge-sort coming from? Can you s
Hello,
at Prato PgDay in 2007 I remember hearing in a speech about a (then
yet to come) "seqscan piggyback" feature, allowing concurrent
sequential scans to use the same disk reads. I've now googled for info
about this feature, but I found nothing conclusive (e.g. [1], [2] -
which I don't know whe
On Mon, Feb 22, 2010 at 2:15 PM, Frank Heikens wrote:
>
> Op 22 feb 2010, om 20:07 heeft Yang Zhang het volgende geschreven:
>
>> On Mon, Feb 22, 2010 at 1:48 PM, Alban Hertroys
>> wrote:
>>>
>>> On 22 Feb 2010, at 19:35, Yang Zhang wrote:
>>>
I also wouldn't have imagined an external merge-
Yang Zhang escribió:
> I have the exact same table of data in both MySQL and Postgresql. In
> Postgresql:
I just noticed two things:
[snip lots of stuff]
1.
> ) ENGINE=MyISAM AUTO_INCREMENT=50410166 DEFAULT CHARSET=latin1
You're doing a comparison to MyISAM.
2.
> select * from metarelclo
On Mon, Feb 22, 2010 at 2:27 PM, Alvaro Herrera
wrote:
> Yang Zhang escribió:
>> I have the exact same table of data in both MySQL and Postgresql. In
>> Postgresql:
>
> I just noticed two things:
>
> [snip lots of stuff]
>
> 1.
>
>> ) ENGINE=MyISAM AUTO_INCREMENT=50410166 DEFAULT CHARSET=latin1
>
On Mon, Feb 22, 2010 at 12:30 PM, Yang Zhang wrote:
> This isn't some microbenchmark. This is part of our actual analytical
> application. We're running large-scale graph partitioning algorithms.
It's important to see how it runs if you can fit more / most of the
data set into memory by cranking
Op 22 feb 2010, om 20:28 heeft Yang Zhang het volgende geschreven:
If your work-mem is too low there's a good chance that Postgres
has to
use your disks for sorting, which will obviously be quite slow.
Relative to the non-terminating 80-minute-so-far sort, Unix sort
runs
much faster
Thanks, I got these working:
$query = "SELECT
lessonwebid,lessontitle,gradelevel,grademin,grademax,reviewedby FROM
lessonplans WHERE grademin >= 3 AND grademin <= 5 OR grademax >= 3 AND
grademax <= 5";
Raymond O'Donnell wrote:
>
> On 22/02/2010 18:14, flashbangpop wrote:
>
>> I'm new to pos
On Mon, Feb 22, 2010 at 2:39 PM, Scott Marlowe wrote:
> On Mon, Feb 22, 2010 at 12:30 PM, Yang Zhang wrote:
>> This isn't some microbenchmark. This is part of our actual analytical
>> application. We're running large-scale graph partitioning algorithms.
>
> It's important to see how it runs if yo
On Mon, Feb 22, 2010 at 11:10 AM, Yang Zhang wrote:
> I have the exact same table of data in both MySQL and Postgresql. In
> Postgresql:
Just wondering, are these on the same exact machine?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscripti
Daniele Varrazzo wrote:
> Hello,
>
> at Prato PgDay in 2007 I remember hearing in a speech about a (then
> yet to come) "seqscan piggyback" feature, allowing concurrent
> sequential scans to use the same disk reads. I've now googled for info
> about this feature, but I found nothing conclusive (e.
On Mon, Feb 22, 2010 at 2:52 PM, Scott Marlowe wrote:
> On Mon, Feb 22, 2010 at 11:10 AM, Yang Zhang wrote:
>> I have the exact same table of data in both MySQL and Postgresql. In
>> Postgresql:
>
> Just wondering, are these on the same exact machine?
>
Yes, on the same disk.
--
Yang Zhang
htt
On Mon, Feb 22, 2010 at 12:50 PM, Yang Zhang wrote:
> On Mon, Feb 22, 2010 at 2:39 PM, Scott Marlowe
> wrote:
>> On Mon, Feb 22, 2010 at 12:30 PM, Yang Zhang wrote:
>>> This isn't some microbenchmark. This is part of our actual analytical
>>> application. We're running large-scale graph partiti
Daniele Varrazzo wrote:
> Hello,
>
> at Prato PgDay in 2007 I remember hearing in a speech about a (then
> yet to come) "seqscan piggyback" feature, allowing concurrent
> sequential scans to use the same disk reads. I've now googled for info
> about this feature, but I found nothing conclusive (
On Mon, Feb 22, 2010 at 2:41 PM, Frank Heikens wrote:
>
> Op 22 feb 2010, om 20:28 heeft Yang Zhang het volgende geschreven:
>>
>>
>>>
>>>
> If your work-mem is too low there's a good chance that Postgres has to
> use your disks for sorting, which will obviously be quite slow.
Re
On 22/02/10 09:57, Patryk Sidzina wrote:
Hello everyone,
my company has been using pg_standby as a replication solution for a
while and it has been working great for our needs. Unfortunately, about
once a month we get the following error on the standby bases:
vacuumdb: vacuuming of database "xx
On Mon, Feb 22, 2010 at 7:59 PM, Andreas Kretschmer
wrote:
> Daniele Varrazzo wrote:
>
>> Hello,
>>
>> at Prato PgDay in 2007 I remember hearing in a speech about a (then
>> yet to come) "seqscan piggyback" feature, allowing concurrent
>> sequential scans to use the same disk reads. I've now goog
Scott Marlowe wrote:
On Mon, Feb 22, 2010 at 11:10 AM, Yang Zhang wrote:
I have the exact same table of data in both MySQL and Postgresql. In Postgresql:
Just wondering, are these on the same exact machine?
Just reading up on this interesting thread. WFIW, 2 years ago I and a
col
Yang Zhang writes:
> On Mon, Feb 22, 2010 at 1:13 PM, Pavel Stehule
> wrote:
>> the speed depends on setting of working_memory. Try to increase a
>> working_memory
> It's already at
> 2kB
According to your original posting, you're trying to sort something like
a gigabyte of data. 20MB i
On Mon, Feb 22, 2010 at 12:53 PM, Yang Zhang wrote:
> On Mon, Feb 22, 2010 at 2:52 PM, Scott Marlowe
> wrote:
>> On Mon, Feb 22, 2010 at 11:10 AM, Yang Zhang wrote:
>>> I have the exact same table of data in both MySQL and Postgresql. In
>>> Postgresql:
>>
>> Just wondering, are these on the s
dipti shah writes:
> I have just noticed that "SET ROLE" doesn't work from security definer
> function. I don;t know why but it clearly gives the error that SET role
> doesn;t work in security definer context.
This is intentional because allowing it creates security holes.
> If I create function
On Mon, Feb 22, 2010 at 3:44 PM, Tom Lane wrote:
> Yang Zhang writes:
>> On Mon, Feb 22, 2010 at 1:13 PM, Pavel Stehule
>> wrote:
>>> the speed depends on setting of working_memory. Try to increase a
>>> working_memory
>
>> It's already at
>> 2kB
>
> According to your original posting, yo
Yeb Havinga writes:
> Just reading up on this interesting thread. WFIW, 2 years ago I and a
> collegue of mine did a hardware comparison of early Intel and AMD
> desktop quadcore processors to run postgres database, with most other
> parts comparable. The intel processor was 20 to 30 % faster i
When in doubt - test.
Why not remove index in MySQL (or create index in PostgreSQL) and see
what happens.
Why trying compare "apples and oranges"?
Igor Neyman
> -Original Message-
> From: Yang Zhang [mailto:yanghates...@gmail.com]
> Sent: Monday, February 22, 2010 1:37 PM
> To: Richard
On Mon, Feb 22, 2010 at 5:31 PM, Igor Neyman wrote:
> When in doubt - test.
> Why not remove index in MySQL (or create index in PostgreSQL) and see
> what happens.
> Why trying compare "apples and oranges"?
Continue reading this thread -- I also tried using an index in Postgresql.
--
Yang Zhang
On Mon, Feb 22, 2010 at 3:33 PM, Yang Zhang wrote:
> On Mon, Feb 22, 2010 at 5:31 PM, Igor Neyman wrote:
>> When in doubt - test.
>> Why not remove index in MySQL (or create index in PostgreSQL) and see
>> what happens.
>> Why trying compare "apples and oranges"?
>
> Continue reading this thread
On Mon, Feb 22, 2010 at 3:33 PM, Yang Zhang wrote:
> On Mon, Feb 22, 2010 at 5:31 PM, Igor Neyman wrote:
>> When in doubt - test.
>> Why not remove index in MySQL (or create index in PostgreSQL) and see
>> what happens.
>> Why trying compare "apples and oranges"?
>
> Continue reading this thread
On Feb 17, 2010, at 6:38 PM, Greg Smith wrote:
> Ben Chobot wrote:
>> Is there a way to tell if I really am just keeping the same few pages dirty
>> throughout every checkpoint? I wouldn't have expected that, but given our
>> application I suppose it is possible.
>
> You can install pg_bufferca
Ben Chobot wrote:
Is it reading it correctly to say that the bgwriter probably wouldn't
help much, because a majority of the dirty pages appear to be popular?
Yes. The background writer cleaner process only does something useful
if there are pages with low usage counts it can evict. You woul
On Mon, Feb 22, 2010 at 11:10, Yang Zhang wrote:
> I have the exact same table of data in both MySQL and Postgresql. In ?>
> Postgresql:
FWIW on a stock (unchanged postgresql.conf) 8.3.9 I get (best of 3
runs) 79 seconds, 26 using an index and 27 seconds with it clustered.
Now yes it goes a lot
Anyone out there interested in a San Diego PostgreSQL Users Group?
If so, I created a meetup here:
http://www.meetup.com/SD-PUG/
Please sign up and contact me off list.
Thanks,
Joe
signature.asc
Description: OpenPGP digital signature
Recently I read that one of the distinctions between a standard database
and
a columnar one, which led to an increase in its efficiency, was and I
quote:
"Only relevant columns are retrieved (A row-wise database would pull
all columns and typically discard 80-95% of them)"
Is this true of
On Mon, Feb 22, 2010 at 07:23:09PM -0700, dmp wrote:
>
> Recently I read that one of the distinctions between a standard database
> and
> a columnar one, which led to an increase in its efficiency, was and I
> quote:
>
> "Only relevant columns are retrieved (A row-wise database would pull
> all
Hi all,
I am dumping both schema and data from old database to new one. The new
database schema is somehow contain slightly different schema then the old
one. When I do restore it shown alot errors related with constraints. How
can I dump and to restore from old to new without dealing with constra
"Net Tree Inc." wrote:
> When I do restore it shown alot errors related with constraints.
> How can I dump and to restore from old to new without dealing with
> constraint and just forces data dump to where it suppose to belong?
What version are you dumping from and to? Exactly what errors ar
Net Tree Inc. wrote:
Hi all,
I am dumping both schema and data from old database to new one. The
new database schema is somehow contain slightly different schema then
the old one. When I do restore it shown alot errors related with
constraints. How can I dump and to restore from old to new wi
I have updated the documentation to be more direct about COPY encoding
behavior. Patch attached and applied.
---
Peter Headland wrote:
> > Maybe the link might help?
> >
> > http://www.postgresql.org/docs/8.4/interactive/m
Andreas Kretschmer wrote:
> Hi,
>
> There is a question in the german pg-forum:
>
> It is possible to add a comment on a constraint, but \dd doesn't display
> that comment. There is also a old question in this mailing-list without
> an answer:
> http://archives.postgresql.org/pgsql-general/2003-0
nOn Mon, Feb 22, 2010 at 3:45 PM, Scott Marlowe
wrote:
> On Mon, Feb 22, 2010 at 12:53 PM, Yang Zhang wrote:
>> On Mon, Feb 22, 2010 at 2:52 PM, Scott Marlowe
>> wrote:
>>> On Mon, Feb 22, 2010 at 11:10 AM, Yang Zhang wrote:
I have the exact same table of data in both MySQL and Postgr
On Mon, Feb 22, 2010 at 9:30 PM, Alex Hunsaker wrote:
> On Mon, Feb 22, 2010 at 11:10, Yang Zhang wrote:
>> I have the exact same table of data in both MySQL and Postgresql. In ?>
>> Postgresql:
>
> FWIW on a stock (unchanged postgresql.conf) 8.3.9 I get (best of 3
> runs) 79 seconds, 26 using a
Bruce Momjian writes:
> I have updated the documentation to be more direct about COPY encoding
> behavior. Patch attached and applied.
Uh, why exactly do you find that better? "Processes data" seems a lot
vaguer to me than the previous wording. I certainly don't think that
this does much to ad
Tom Lane wrote:
> Bruce Momjian writes:
> > I have updated the documentation to be more direct about COPY encoding
> > behavior. Patch attached and applied.
>
> Uh, why exactly do you find that better? "Processes data" seems a lot
> vaguer to me than the previous wording. I certainly don't thi
Yang Zhang writes:
>> # select count(1) from (SELECT * from metarelcould_transactionlog
>> order by transactionid) as foo;
> Does it strike anyone else that the query optimizer/rewriter should be
> able to toss out the sort from such a query altogether?
It could, if it knew that the aggregate fu
Yang Zhang writes:
> I'm relieved that Postgresql itself does not, in fact, suck, but
> slightly disappointed in the behavior of psql. I suppose it needs to
> buffer everything in memory to properly format its tabular output,
> among other possible reasons I could imagine.
That's half of it, and
Ok, I am just trying to find the proper way to back and restore database
that contain restriction.
The other way to ask. If I have two 99% schema similar databases. The old
one might contain few columns that does not exist in the new one and contain
constrains that the new DB does not have. In tha
On Mon, Feb 22, 2010 at 10:51 PM, Yang Zhang wrote:
> nOn Mon, Feb 22, 2010 at 3:45 PM, Scott Marlowe
> wrote:
>>
>> What do things like vmstat 10 say while the query is running on each
>> db? First time, second time, things like that.
>
> Awesome -- this actually led me to discover the prob
On Mon, Feb 22, 2010 at 22:51, Yang Zhang wrote:
> vmstat showed no swapping-out for a while, and then suddenly it
> started spilling a lot. Checking psql's memory stats showed that it
> was huge -- apparently, it's trying to store its full result set in
> memory. As soon as I added a LIMIT 1,
On Tue, Feb 23, 2010 at 1:48 AM, Scott Marlowe wrote:
> On Mon, Feb 22, 2010 at 10:51 PM, Yang Zhang wrote:
>> nOn Mon, Feb 22, 2010 at 3:45 PM, Scott Marlowe
>> wrote:
>>>
>>> What do things like vmstat 10 say while the query is running on each
>>> db? First time, second time, things like
Hi,
I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in the
process of restoring the databases in Postgres 8.3.8. There were lots errors
showed on the screen when I ran this command 'psql -e template1 -f 21.bak' and
it actually displayed the line numbers where the errors occu
On Mon, 22 Feb 2010 23:19:34 -0800, "Wang, Mary Y"
wrote:
> Hi,
>
> I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in
the
> process of restoring the databases in Postgres 8.3.8. There were lots
> errors showed on the screen when I ran this command 'psql -e template1
-f
> 21.b
Wang, Mary Y wrote:
Hi,
I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in the process
of restoring the databases in Postgres 8.3.8. There were lots errors showed on
the screen when I ran this command 'psql -e template1 -f 21.bak' and it actually
displayed the line numbers
On 02/23/2010 12:54 PM, Nilesh Govindarajan wrote:
On 02/23/2010 12:49 PM, Wang, Mary Y wrote:
Hi,
I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in
the process of restoring the databases in Postgres 8.3.8. There were
lots errors showed on the screen when I ran this command
On Mon, Feb 22, 2010 at 11:39 PM, Net Tree Inc. wrote:
> Ok, I am just trying to find the proper way to back and restore database
> that contain restriction.
> The other way to ask. If I have two 99% schema similar databases. The old
> one might contain few columns that does not exist in the new o
No. I dumped the 7.1 with the 7.1 version of pg_dump.
Is it better to dump with the 8.3 version of pg_dump? I thought I read it some
where in the mailing lists. I don't know how I would be able to dump with the
8.3 version of pg_dump. The database and Postgres 7.1 is loaded on the current
pro
1 - 100 of 103 matches
Mail list logo
