Josh Berkus wrote:
Tom,
Right, because they do. If you think otherwise, demonstrate it.
(bonnie tests approximating a reverse seqscan are not relevant
to the performance of indexscans.)
Working on it. I *think* I've seen this issue in the field, which is
why I brought it up in the first pl
On Wed, 2009-04-15 at 09:51 -0400, Tom Lane wrote:
> Brian Cox writes:
> > I changed the logic to update the table in 1M row batches. However,
> > after 159M rows, I get:
>
> > ERROR: could not extend relation 1663/16385/19505: wrote only 4096 of
> > 8192 bytes at block 7621407
>
> You're ou
Brian Cox writes:
> I changed the logic to update the table in 1M row batches. However,
> after 159M rows, I get:
> ERROR: could not extend relation 1663/16385/19505: wrote only 4096 of
> 8192 bytes at block 7621407
You're out of disk space.
> A df run on this machine shows plenty of space:
On Wed, 15 Apr 2009, Matthew Wakeling wrote:
If anyone needs this code in Java, we have a version at
http://www.intermine.org/
Download source code: http://www.intermine.org/wiki/SVNCheckout
Javadoc: http://www.intermine.org/api/
Sorry, that should be http://www.flymine.org/api/
Matthew
--
On Tue, 14 Apr 2009, Stephen Frost wrote:
What does your test harness currently look like, and what would you like
to see to test the binary-format COPY? I'd be happy to write up the
code necessary to implement binary-format COPY for this.
If anyone needs this code in Java, we have a version a
Hey guys,
I need some information on
1. What are the best features of Npgsql product as compare to other
commercial .net data providers?
2. If you have encountered any major problems, bugs or performance issue
etc... With this product?
Thanks in advance,
Peeyush Jain| Software Engineer
On Wed, Apr 15, 2009 at 1:41 AM, Brian Cox wrote:
> ts_defect_meta_values has 460M rows. The following query, in retrospect not
> too surprisingly, runs out of memory on a 32 bit postgres:
>
> update ts_defect_meta_values set ts_defect_date=(select ts_occur_date from
> ts_defects where ts_id=ts_de
