Dear Friends,
How to insert or update a file in a table using the query in postgres
CREATE TABLE excel_file_upload
(
user_id integer,
excel_file bytea
}
example
insert into excel_file_upload values(1,file1)
file1 can be any file *.doc,*.xls
How i can do this(with out using java or
Dear Friends,
How to insert or update a file in a table using the query in postgres
CREATE TABLE excel_file_upload
(
user_id integer,
excel_file bytea
}
example
insert into excel_file_upload values(1,file1)
file1 can be any file *.doc,*.xls
How i can do this(with out using java or
Hi,
Greg Smith gsm...@gregsmith.com writes:
I keep falling into situations where it would be nice to host a server
somewhere else. Virtual host solutions and the mysterious cloud are no good
for the ones I run into though, as disk performance is important for all the
applications I have to
ramasubramanian wrote:
How to insert or update a file in a table using the query in postgres
CREATE TABLE excel_file_upload
(
user_id integer,
excel_file bytea
}
example
insert into excel_file_upload values(1,file1)
file1 can be any file *.doc,*.xls
How i can do
ramasubramanian, 27.05.2009 08:42:
How to insert or update a file in a table using the query in postgres
CREATE TABLE excel_file_upload
(
user_id integer,
excel_file bytea
}
example
insert into excel_file_upload values(1,file1)
file1 can be any file *.doc,*.xls
How i can do
Hey folks,
During Greg Smith's lecture last week I could have sworn I saw on the
screen at some point a really long command line for bonnie++ - with
all the switches he uses.
But checking his slides I don't see this.
Am I mis-remembering?
Can someone recommend the best way to run it? What
You should be able to get a good idea of the options from man bonnie++. I've
always just used the defaults with bonnie++
Also, you'll find Gregs older notes are here
http://www.westnet.com/~gsmith/content/postgresql/pg-disktesting.htm
--- On Wed, 27/5/09, Alan McKay alan.mc...@gmail.com
On Tue, 2009-05-26 at 19:52 -0600, Scott Marlowe wrote:
On Tue, May 26, 2009 at 7:41 PM, Scott Carey sc...@richrelevance.com wrote:
On 5/26/09 6:17 PM, Greg Smith gsm...@gregsmith.com wrote:
On Tue, 26 May 2009, Joshua D. Drake wrote:
CMD doesn't rent hardware you would have to
So Google hasn't been helpful and I'm not entirely sure what to look
for in the mailing lists to find the answer to my problem, so here
goes.
I have a query and I have run
explain analyze
select count(*)
from score
where leaderboardid=35 and score = 6841 and active
The result is
Aggregate
try creating index on all three columns.
Btw, 38ms is pretty fast. If you run that query very often, do prepare
it, cos I reckon it takes few ms to actually create plan for it.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
Heh. Well on another consideration any rental will out live its cost
effectiveness in 6 months or less. At least if you own the box, its
useful for a long period of time.
Heck I got a quad opteron, 2 gig of memory with 2 6402 HP controllers
and 2 fully loaded MSA30s for 3k. Used of course but
On Wed, 27 May 2009, Alan McKay wrote:
During Greg Smith's lecture last week I could have sworn I saw on the
screen at some point a really long command line for bonnie++ - with
all the switches he uses.
You're probably thinking of the one I showed for sysbench, showing how to
use it to run a
On Tue, May 26, 2009 at 7:58 PM, Dave Page dp...@pgadmin.org wrote:
On 5/26/09, Greg Smith gsm...@gregsmith.com wrote:
I keep falling into situations where it would be nice to host a server
somewhere else. Virtual host solutions and the mysterious cloud are no
good for the ones I run into
The plan ought to be different when there are more scores and the table is
analyzed and your statistics target is high enough. At this point you don't
have enough data to merit doing anything but a seq scan. The overhead is
simply not worth it.
You could try inserting a lot more rows. I'd
I'm running the inserts now via a JDBC call I have, which is then
followed up by the query I'm showing and a few others. I have run
tests on all of the others, and all others run index scans and are
very fast, 10 ms or less. This one started at 2 milliseconds when the
table is empty and is up to
you have to vacuum analyze after you've created index, afaik.
No, count(*) is still counting rows.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Still getting a seq scan after doing vacuum analyze. Any other ideas?
2009/5/27 Grzegorz Jaśkiewicz gryz...@gmail.com:
you have to vacuum analyze after you've created index, afaik.
No, count(*) is still counting rows.
--
Sent via pgsql-performance mailing list
Zach Calvert wrote:
Still getting a seq scan after doing vacuum analyze. Any other ideas?
Try CLUSTERing the table on the (leaderboardid, active, score) index.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-performance mailing list
Hey folks,
I have done some googling and found a few things on the matter. But
am looking for some suggestions from the experts out there.
Got any good pointers for reading material to help me get up to speed
on PostgreSQL clustering? What options are available? What are the
issues?
On Wed, May 27, 2009 at 1:57 PM, Alan McKay alan.mc...@gmail.com wrote:
Hey folks,
I have done some googling and found a few things on the matter. But
am looking for some suggestions from the experts out there.
Got any good pointers for reading material to help me get up to speed
on
Alan,
here I'm implementing something similar to the Chord protocol [1] on the
application level to partition my data across 6 PostgreSQL servers with N+1
replication. Two up sides on this approch:
1 - When one server is down the load is spread between all the other ones,
instead of going only
Hi,
Le 27 mai 09 à 19:57, Alan McKay a écrit :
I have done some googling and found a few things on the matter. But
am looking for some suggestions from the experts out there.
Got any good pointers for reading material to help me get up to speed
on PostgreSQL clustering? What options are
22 matches
Mail list logo
