;
> *From:* francisco.figueiredo...@gmail.com [mailto:
> francisco.figueiredo...@gmail.com] *On Behalf Of *Francisco Figueiredo Jr.
> *Sent:* Friday, March 09, 2012 12:41 PM
> *To:* Randy Ficker
> *Cc:* Marti Raudsepp; pgsql-general@postgresql.org
> *Subject:* RE: [GENERAL] 9.1 causing &q
raight back down to the 8.4 level. Awesome!
>
> ** **
>
> Thanks for the quick replies guys!
>
> ** **
>
> *From:* francisco.figueiredo...@gmail.com [mailto:
> francisco.figueiredo...@gmail.com] *On Behalf Of *Francisco Figueiredo Jr.
> *Sent:* Friday, Marc
Thanks for the heads up.
I'll fix that in Npgsql so it sends the correct isolation level when
running on 9.1+
Sent from my Android phone
On Mar 9, 2012 3:27 PM, "Randy Ficker" wrote:
> Hey Marti,
>
> I almost replied that yes, I was 100% sure, since I know my code requests
> the REPEATABLE READ
ing datatype which
>> maps to postgresql bit fields which could give you the information you
>> want. But I don't know if it would be too much overkill for your
>> rating system.
>> BitString datatype already have a lot of helpers methods though
>> including one
ter varying, OUT recipecount integer, out ingredientcount
> integer)
> RETURNS SETOF record AS
> $BODY$
> BEGIN
> -- All sorts of stuff way too mind-blowing for this email
> END;
>
> Then I call it as so:
>
> IDbCommand cmd = session.Connection.Cr
On Sun, Jan 8, 2012 at 21:31, Mike Christensen wrote:
> On Sun, Jan 8, 2012 at 10:12 AM, Francisco Figueiredo Jr.
> wrote:
>> On Sun, Jan 8, 2012 at 06:54, Mike Christensen wrote:
>>>>>>>> According to the manuals, Postgres has smallint (2 byte), integer (4
d since a byte type isn't required by
>> the SQL spec, it would take some effort to get a standard one included
>> in the core.
>
> That makes sense.
>
> I guess my question is more of a NpgSql question then. Is there a way
> to create a custom PG type, and have npgs
elational
> features like hstore through a layer that tries to be db-independent and
> purely relational. I don't have any experience with Castle ActiveRecord.
> When I've used hstore with hibernate I've always done it by direct native
> queries.
>
> --
> Craig Ri
1], '.') as weight
> from product_list
>
> Looks simpler than using XmlReader, isn't it?
> How to invoke asmx web service call (= http POST request) from
> PostgreSql server which reads http response to xml_import table ?
>
> How to call stored proce
> 6500
> 6501
> 65010200
> 10001125
> AM
> Acme API Specification v 1.0
> 13
> ADA3000AXBOX
> AMD Athlon64 3000+ (2000MHz/1600MHz/L2 Cache 512KB) Socket 754,
> BOX
> 36
> 296.0
> 0
> 3.6000
> 1999-01-01T00:00:00
> false
>
>
>
>
you. Sorry for that.
On the good side, we released a new beta last week. :)
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://gplus.to/franciscojunior
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
<>
the right choice for ORM framework of .NET.
>
> I want to know whether there is any efficient .NET provider and is PGSQL
> compatible with the .NET entity framework.
>
> Regards,
> Rohit.
>
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http:/
w bug reports and checking the
status of current bugs.
Thanks in advance and again, sorry for bothering you in this list.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
--
Sent via pgsql-gener
ive it a try and feel free to let us know if you find any problem.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
phone
Francisco Figueiredo Jr.
Npgsql lead developer
fxjr.blogspot.com
twitter.com/franciscojunior
Em 18/03/2011 22:01, "Tom Lane" escreveu:
> "Francisco Figueiredo Jr." writes:
>> My database has encoding set to UTF-8 although my lc_collate is
pt.BR.UTF-8
>> th
ting my have cause some trouble?
I also have problems with psql client where the char doesn't appear at all.
Andreas could see the char though...
I hope it helps.
Thanks in advance.
--
Sent from my Android phone
Francisco Figueiredo Jr.
Npgsql lead developer
fxjr.blogspot.com
twitter.com/f
Any ideas??
Would it be possible that Postgresql would be using another encoding
for the identifiers when they aren't wrapped by double quotes?
On Tue, Mar 15, 2011 at 23:37, Francisco Figueiredo Jr.
wrote:
> Now, I'm using my dev machine.
>
> With the tests I'm doing,
compiled postgresql 9.0.1 from source code.
Thanks in advance.
[1] - http://en.wikipedia.org/wiki/UTF-8
On Tue, Mar 15, 2011 at 15:52, Francisco Figueiredo Jr.
wrote:
> H,
>
> What would change the encoding of the identifiers?
>
> Because on my dev machine which unfor
ere any config I can change at runtime in order to have it
returned correctly?
Thanks in advance.
On Tue, Mar 15, 2011 at 15:45, Andreas Kretschmer
wrote:
> Francisco Figueiredo Jr. wrote:
>
>>
>> What happens if you remove the double quotes in the column name identifier?
>
>
7;t test putting double quotes in the column name identifier as
the bug report isn't using it.
What happens if you remove the double quotes in the column name identifier?
Thanks in advance.
On Tue, Mar 15, 2011 at 15:21, Andreas Kretschmer
wrote:
> Francisco Figueiredo Jr. wrote:
>
ion I need to change to specify the encoding of
the identifiers?
I'm using UTF-8 for my database.
Thanks in advance.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
--
Sent via pgsql-general mail
That's great!
I'm glad to hear it.
Thank you very much for providing patches for this issue.
--
Sent from my Android phone
Francisco Figueiredo Jr.
Npgsql lead developer
fxjr.blogspot.com
twitter.com/franciscojunior
Em 10/03/2011 09:01, "Ahmed Shinwari" escreveu:
> Hi
ards,
> Radek
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fx
instead of Brar's code wouldn't break cases like the one he said in
his last email?
Thanks for feedback.
On Wed, Feb 2, 2011 at 14:11, Francisco Figueiredo Jr.
wrote:
> Thank you very much for your patch!
>
> I'm going to review and apply it.
>
> As soon as it is done
tml
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Fi
Francisco Figueiredo Jr
Sent from my Android phone.
Em 21/01/2011 13:50, "orgilhp" escreveu:
>
> Hello,
Hello!
> I have postgresql 8.3.9 database. Now I am working on reading file
> from bytea data and save to filesystem.
> I am using Npgsql.dll on c#.net.
>
Whi
# hex, escape
>>
>> into postgresql.conf.
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
--
Regards,
la base de firmas
> de virus 5575 (20101029) __
>
> ESET NOD32 Antivirus ha comprobado este mensaje.
>
> http://www.eset.com
>
> __ Información de ESET NOD32 Antivirus, versión de la base de firmas
> de virus 5575 (20101029) __
>
> ESET NOD32 A
ums linked to off that page. It looks like the
> npgsql folks primarily use forums and the tracker for user support.
>
Yeap. That's our primary support way.
But I also keep eye on general, dev and interfaces mailing list in
case something about Npgsql appears.
--
Regards,
Francis
atul.g...@globaldatapoint.com writes:
to be killed? What is the best way to kill a session in Postgres?
Just plain kill would have worked better. I believe the issue is with the
'-9'.
Also see
http://www.postgresonline.com/journal/index.php?/archives/134-Terminating-An
noying-Back-Ends.ht
Is there a way to see the status of autovacuum_enabled for a table?
The reason I am asking is because I am seeing tables getting vacuumed which
I had set autovacuum_enabled to false. The autovacuum was already running
when I set the setting for a large number of tables.
If I had 5 tables
a
b
Whooops,
I didn't check the message header...
You can ignore my first question :)
On Mon, Aug 23, 2010 at 15:56, Francisco Figueiredo Jr.
wrote:
> Are you using Npgsql with NHibernate?
>
> We added an option to send this command when starting a connection.
>
> But the set
l@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ll use this if there's no other way.
>>
>
> Just run them in one transaction.
> You can also just show the Next/Prev buttons and then do something just for
> the case where there is no data.
> Or use LIMIT 31 so you always know that there is the next page with at least
&g
y cast to either a string or an int and I
>> shouldn't have to worry about that. Thanks!!
>>
>> Mike
>>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Merlin Moncure writes:
do a big delete recently? any other open transactions?
Some inserts were taking place. Roughly 2 to 5 million rows inside
transactions. We were doing some ETL and each batch represented a file we
were loading. We need to have the entire file or roll back so each file
Tom Lane writes:
Francisco Reyes writes:
I am trying to do
select max(primary_key) from some_table;
Are there a whole lot of nulls in that column?
Zero nulls. It is a primary key.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
Postgres 8.4.1
CentOS 5.4
I am trying to do
select max(primary_key) from some_table;
The explain looks like:
explain select max(primary_key) from some_table;
QUERY PLAN
-
pAdapter = new NpgsqlDataAdapter();
> NpAdapter.SelectCommand = new NpgsqlCommand(query, conn);
> NpAdapter.Fill(dset, "npdata");
> dtsource = dset.Tables["npdata"];
>
> deleteCmd();
> updateCmd();
> insertCmd();
> }
>
&
The alter index page does not show the lock mode, but it seems it is an
ACCESS EXCLUSIVE.
Wouldn't an EXCLUSIVE lock be more appropriate and remove the index from
planner consideration?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Craig Ringer writes:
Possible workaround: Instead of your table creation, renaming and
dropping, use TRUNCATE.
Have to support both 8.1 and 8.4.
If I recall correctly 8.1 did not support truncate inside of a transaction.
We are in the process of upgrading everything to 8.4, but until then.. h
Sam Mason writes:
maybe something like "pv" would help?
http://www.ivarch.com/programs/pv.shtml
I think it may help the OP, but indexes are still going to be a rough spot..
if large table has several indexes the output from pv will be missleading.
--
Sent via pgsql-general mailing list
Leonardo M. Ramé writes:
A customer of mine asked me to periodically delete old, unneeded records
containing ByteA fields, because he think it will reduce the database
size on disk. Is this true?.
No.
For example, in Firebird, the database size
is not reduced until you do a Backup-Restore of
Ivan Sergio Borgonovo writes:
It get a bit better but even knowing what are the largest tables it
is hard to get an estimate of how much is missing before complete
restore.
Agree. Also building indexes can also take quite some time.
I'm really looking at rough figures... even a: I've read 40
I need to replace a table with a new one.
Example..
I create a script that continously does selects like
select count(*) from tmp_deleteme_francisco;
enough selects to last the duration of second script
select count(*) from tmp_deleteme_francisco;
Another script then does
begin;
select * in
Ivan Sergio Borgonovo writes:
Is there a way to know/estimate how much is left to complete a
restore?
Not sure on plain ASCII files but if your pg_dump used Fc then at restore
you can pass the -v flag.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
Devrim GÜNDÜZ writes:
On Tue, 2009-12-22 at 15:10 -0500, Francisco Reyes wrote:
Only up to 8.4.1 there.
Which os/distro are you looking for? I hope it is not Fedora 11 -
x86_64.
CentOS x86_64
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
They also used to be at ftp.postgresql.org:/pub/binary.
There are only rpms up to 8.4.1
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
A. Kretschmer writes:
http://yum.pgsqlrpms.org/reporpms/repoview/letter_p.group.html
Only up to 8.4.1 there.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Dec 1, 2009 at 21:39, Howard Cole wrote:
> Howard Cole wrote:
>>
>> Interesting what Francis says about the pool connections being closed
>> before disposal.
>
> Apologies "Francisco"
>>
:) No problem.
>> Presumably I should never get th
ool values in your connection string. Try to put a higher
value of min connection pool, so they aren't closed too frequently.
Also, as Richard said, check your connection usage pattern in your application.
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http:
Is there a way to tell to which table a DEFAULT rule belongs to?
Example:
Have multiple files with serial. The sequence is setup as a default. Because
all tables have the same structure the DEFAULT lines on a file pg_dumped
with -Fc look the same.
The lines look like
DEFAULT public id user
DE
ented methods. It is
strongly advised that current users update from Npgsql1 to Npgsql2"
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior
Sent from Brasilia, DF, Brazil
--
Sent v
On Tue, May 12, 2009 at 05:02, Richard Huxton wrote:
> Francisco Figueiredo Jr. wrote:
>>
>> Hi all!
>>
>> I was playing with "in (...)" and "= any (...)" queries and found a
>> difference between them and I wonder:
>>
>> why this
eger_column in (array[5,6]);
Although documentation says:
9.20.4. ANY/SOME
[...]
SOME is a synonym for ANY. IN is equivalent to = ANY.
[...]
I thought that if IN is equivalent to = any, both queries above should work.
Am I missing something?
Thanks in advance.
--
Regards,
Francisco Figueiredo
t;
> Thanks & regards,
>
> Peeyush Jain | Software Engineer –Netezza Dev | Persistent Systems Ltd
>
> peeyush_j...@persistent.co.in | Cell: +91 9373069475 | Tel: +91 (20) 3023
> 6762
>
> Innovation in software product design, development and delivery-
> www.persiste
ed recipient, you are not authorized to read, retain,
> copy, print, distribute or use this message. If you have received this
> communication in error, please notify the sender and delete all copies of
> this message. Persistent Systems Ltd. does not accept any liability fo
support for returning
setof refcursor. You can check examples about how to do that
in our user manual: http://manual.npgsql.org
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have executed pg_config and I have the libxml. I think the problem is that
xml2 is not enabled, any idea how to enable it?
2009/2/19 Osvaldo Kussama
> 2009/2/19 Francisco :
> > I saw it,but it says:
> > "Use of many of these functions requires the installation to have b
I saw it,but it says:
"Use of many of these functions requires the installation to have been built
with configure --with-libxml"
When I installed postgreSQL I did not include this option, have I to
reinstall postgresql?
2009/2/19 Osvaldo Kussama
> 2009/2/19 Francisco :
> >
Hi List,
I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron.
I want to use xpath functions (like xpath_table), but I can't. An error
appears "xpath_table does not exists".
How could I intregrate xpath funtions with my postgreSQL without
reinstalling it?
Any solution?
Thanks ;)
On Fri, Jan 23, 2009 at 11:25 AM, Howard Cole wrote:
> Francisco Figueiredo Jr. wrote:
>>
>> About the memory issue of Npgsql, did you try to use a prepared
>> statement for this? We have some performance improvements when
>> handling bytea values but only when the Npg
have some performance improvements when
handling bytea values but only when the NpgsqlCommand.Prepare() method
is called.
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-ge
gister
Npgsql as a dbproviderfactory.
Also note that Npgsql supports sqlclient parameter style with the '@'
prefix to easy porting sql code from sqlserver to postgresql.
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.o
e file Mono.Security.dll into the GAC as
Npgsql.dll depends on it.
This file is also found in the downloaded file. Maybe you got one for
Mono which already contains the Mono.Security.dll assembly.
If you read the manual and still have doubts, please let us know.
I hope it helps.
--
Regards,
Francisco Figu
me path/dir variable?
>
I think you need to install the developer tools.
I compile postgresql from sources with no problem on osx 10.5.4 but I
installed developer tools before.
The library which is missing is the following:
> configure:2246: checking for C compiler default output file name
>
On Tue, Oct 14, 2008 at 1:18 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Francisco Figueiredo Jr." <[EMAIL PROTECTED]> writes:
>>> ERROR: invalid input syntax for type date: "infinity"
>>> I thought I could use it anywhere in my sql.
>
>
On Tue, Oct 14, 2008 at 12:58 PM, Francisco Figueiredo Jr.
<[EMAIL PROTECTED]> wrote:
> It gives me the following error:
>
> ERROR: invalid input syntax for type date: "infinity"
>
> I thought I could use it anywhere in my sql.
>
> I have to add a cast to t
.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Aug 28, 2008 at 1:42 AM, Francisco Figueiredo Jr.
<[EMAIL PROTECTED]> wrote:
> Hi all!
>
Any clues about this?
Thanks in advance.
> I'm playing with client thread abort issues in Npgsql. And with a test
> sample one of our users provided us we are seeing that
using Postgresql 8.3.3 on OSX 10.5.4
Thanks in advance for any advice about this issue.
--
Regards,
Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
es slower than with the
pool enabled.
--
Regards,
Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.npgsql.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d by default.
>
> //Magnus
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Regards,
Francisco Figueiredo Jr.
http://fxjr.blogspot.com
http://www.np
On 2:08 pm 08/04/08 Rajarshi Guha <[EMAIL PROTECTED]> wrote:
> paircount
> - -
> 123 & 456 1
> 667 & 879 2
create temp table aic_cid
(
id smallint,
cid smallint
);
insert into aic_cid values (1,123);
insert into aic_cid values (2,456);
insert into aic_cid values (3,66
On 4:36 pm 08/01/08 Alex Vinogradovs <[EMAIL PROTECTED]> wrote:
> It's not that I expect a lot of improvement by having non-WAL
> indexing
Have you tried using a fill factor less than 90%?
That is on my list of things to test, but have not done yet.. In particular
you need to find a balance where
On 12:54 pm 07/31/08 "Mike Gould" <[EMAIL PROTECTED]> wrote:
> 1. Is the planner/optimizer intelligent enough to know when we are
> not doing a query based on location?
In short yes.
If the DB doesn't see the condition by which your tables are partitioned it
will search all the partitions.
> 2.
On 1:51 pm 07/30/08 "Ivan Garro" <[EMAIL PROTECTED]> wrote:
> Hola Gente, les comento lo que me pasa,
Esta lista es solo para Ingles.
Favor subscribirte a la lista en espan~ol en:
http://archives.postgresql.org/pgsql-es-ayuda
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
On 10:37 am 07/28/08 Alex Gen <[EMAIL PROTECTED]> wrote:
> 3. Using m01-s2.sql I would like to execute a certain SQL statement
> – BUT within the scope of the transaction begun by m01-s1.sql.
I believe that is not possible.
Specially if you are within a transaction on each of the scripts.
As far
On 9:50 am 07/30/08 "Ian Lea" <[EMAIL PROTECTED]> wrote:
> $ psql -whatever < test.sql > test.log
Also
psql -f > test.log
Almost the same as above..
> > =>\i test.sql \o test
That would be wrong.
Say you had test.sql
select * from mytable;
You can change test.sql to:
\o test.log
select * fro
On 3:19 pm 07/29/08 Alan Hodgson <[EMAIL PROTECTED]> wrote:
> sure you only have 4 cores? Hyper-threading?
It seems Hyperthreading is on in that machine. Going to see if I can have
it turned off.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
On 2:53 pm 07/29/08 Alan Hodgson <[EMAIL PROTECTED]> wrote:
> --sar 2 30
Linux 2.6.9-42.ELsmp (trans03) 07/29/2008
12:58:09 PM CPU %user %nice %system %iowait %idle
12:58:11 PM all 12.44 0.00 0.06 0.00 87.50
12:58:13 PM all 12.44 0
Besides maintenance_work_mem, what else can be changed to improve index
creation?
I just did two tests. One with maintenance_work_mem=128MB and another with
maintenance_work_mem=1GB. Out of 3 single column index, 2 took slightly
longer with the higher value and a third took almost the same.
12GB
On 1:32 pm 07/28/08 "Garg, Manjit" <[EMAIL PROTECTED]> wrote:
> But, actually I want to keep both the Databse in Sync. I want clone db
> to get the data from Master in certain intervals.
Sounds like you are looking for replication. Check
http://wiki.postgresql.org/wiki/Replication%2C_Clustering%
On 9:09 am 07/28/08 Poul Møller Hansen <[EMAIL PROTECTED]> wrote:
> But when selecting a date range I get this
> explain SELECT * FROM public.stat WHERE node = '1010101010' AND
> ("date" <= '2008-06-30'::date AND "date" >= '2008-01-01'::date)
>
> "Bitmap Heap Scan on stat (cost=710.14..179319.44
On 12:44 pm 07/28/08 "Garg, Manjit" <[EMAIL PROTECTED]> wrote:
> I'm stuck to an issue while cloning the pgsql database, can you
> please help, or give any docs to help out.
What is the issue?
> Query - Trying to have same database on two seprate linux servers.
Have you been able to pg_dump f
On 4:53 pm 07/25/08 Zoltan Boszormenyi <[EMAIL PROTECTED]> wrote:
> I don't know. How to determine? Running this as my own user:
Is this your own machine or at an ISP?
If it is your own machine, then most likely you are not in a jail. You
would know if you were since you would have had to do it.
> Is this normal or are there something else I could do so I don't have
> to check if it exists?
I would say that it is normal.
> For the developers: a combined insert/update command would be nice
> :-)
Mysql has such a beast along a some other non SQL compliant extensions.
One possible appro
On 4:12 pm 07/23/08 "Francisco Reyes" <[EMAIL PROTECTED]> wrote:
> Also, that plan is only 3 seconds.
Minor update.
A co-worker is using another DB.. and re-running my query after he did his
work.. now the query using the index scans takes 2 minutes instead of 3
seconds. 3 seco
Table layouts:
historical
Column | Type |Modifiers
---+--+--
record_id | integer | not null default
nextval('historical_record_id_seq'::regclass)
f3| integer
On 3:37 pm 07/23/08 Tom Lane <[EMAIL PROTECTED]> wrote:
> "Francisco Reyes" <[EMAIL PROTECTED]> writes:
> > SET ENABLE_SEQSCAN TO OFF;
> > SET ENABLE_BITMAPSCAN TO OFF;
> > Aggregate (cost=25665216.10..25665216.11 rows=1 width=12) (actual
On 2:23 pm 07/23/08 "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> > However, I do have a current example where bitmap index scan was 3
> > times worse.
> What is your work_mem set to?
For the examples that I posted it is
work_mem = 64MB
--
Sent via pgsql-general mailing list (pgsql-general@p
On 12:00 pm 07/23/08 Shane Ambler <[EMAIL PROTECTED]> wrote:
> > INSERT INTO table (fld_y,fld_z) VALUES ('y','z')
I believe that is the most common way of doing it.
> > which is really doing:
> > INSERT INTO table (fld_x, fld_y,fld_z) VALUES (DEFAULT, 'y','z')
Correct.
So either one should be
On 12:40 pm 07/23/08 Tom Lane <[EMAIL PROTECTED]> wrote:
> That's fairly hard to believe. Care to offer some details?
I will dig that actual project and run explain analyze. Will likely not
have it till middle of next week though because of a monthly process
starting out Friday.
However, I do h
The data set I am working with has a very uneven distribution.
I had to to set random_page_cost = 0.75 to get good plans.
However, that first tries bitmap scans which perform very poorly.
Is there a way to have the planner to favor index scans and disfavor bitmap
scans? Is my best choice to just d
On 6:01 pm 07/21/08 Jack Orenstein <[EMAIL PROTECTED]> wrote:
> to this:
> psql -h $SOURCE_HOST ... -c "copy binary $SOURCE_SCHEMA.$SOURCE_T
> ABLE to
> stdout" |\
> psql ... -c "copy binary $TARGET_SCHEMA.$TARGET_TABLE from stdin"
http://www.postgresql.org/docs/8.3/interactive/sql-copy.html
On 12:33 am 07/22/08 Steve Martin <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am trying to create a PL/PGSQL function to return the values of the
> fields in a record, e.g. 1 value per row in the output of the
> function.
Are you trying to do a generic function that would work for any table or
for just
On 4:05 pm 07/21/08 Jack Orenstein <[EMAIL PROTECTED]> wrote:
> We will now be adding 8.3.x databases to the mix, and will need to
> copy between 7.4.x and 8.3.x in both directions. The datatypes we use
I believe it should work.
Also, one feature I believe started in the 8.X line (8.2?), is the ab
On 11:33 am 07/21/08 "A B" <[EMAIL PROTECTED]> wrote:
> and I want it to be
> A 1
> B 3
> C 44
The slow way
select distinct field1, field2 from sometable.
The faster way
select field1,fields2 from sometable group by field1, field2.
Distinct should in theory be the same speed, but on several test
Alvaro Herrera writes:
Heh -- but are the FKs now checked? Try inserting something that
violates the constraints and see if they are rejected.
I knew it sounded too good to be true.
1- The trigger was not set in the master (ie nothing went to the children).
2- The master had no index and no R
Martijn van Oosterhout wrote:
Can you make them not deferred?
How?
I found the issue.
I had the foreign key in the master table instead of the children.
Deleted RI from master table and put into the inherited partitions.
My whole 230 million rows merged in about an hour!
And I even had two of
301 - 400 of 553 matches
Mail list logo