Michael Fuhr [EMAIL PROTECTED] schrieb:
On Sat, Jun 14, 2008 at 04:59:44PM +0200, Andreas Kretschmer wrote:
Julius Tuskenis [EMAIL PROTECTED] schrieb:
I have a question concerning performance. One of my queries take a long
to execute. I tried to do explain analyse and I see that the
All,
I used to rave about how great the EMS PostgreSQL tools were, but lately
I've been disappointed by the lack of support for their Database
Comparer 2007 for PostgreSQL.
I need a tool that will compare 2 database schemas and allow me to
migrate changes from one database to another. What
Hello, Tom.
So I think the OP's
problem is purely a statistical one, or maybe he's in a situation where
he should reduce random_page_cost.)
What could be done solving that statistical problem? :) Current value
for random_page_cost is 4. What value would you suggest?
Julius Tuskenis
--
加入简历库，让好工作找到你
信息时代，要的就是便捷。企业上网招人，浪费金钱，耽误时间。现在简单了，招聘人才上中国行业人才网（http://job.cnlinfo.net），一边招贤纳士，一边做生意，真正的一站通。
一、企业招聘：在中国行业人才网（http://job.cnlinfo.net）招聘，省时省力，自由彰显公司实力：1、免费，现在真的有免费的午餐了！2、开通网上商铺，展示公司形象，产品，让求职者投放简历更准确。3、招聘之外可进行电子商务，一边招兵买马一边做网上生意。说不定浏览您的招聘信息的，就是您将来的潜在客户！
Hi Michael.
Thank you for your answer. I've checked - enable_nestloop is true. I did
ANALYZE, but that didn't help. The sequential scan is still used Any
more ideas why?
Julius Tuskenis
Michael Fuhr rašė:
On Sat, Jun 14, 2008 at 04:59:44PM +0200, Andreas Kretschmer wrote:
Julius
D. Dante Lorenso wrote on 15.06.2008 01:00:
I need a tool that will compare 2 database schemas and allow me to
migrate changes from one database to another. What tools do the rest of
you use to accomplish this task?
You can try my SQL Workbench/J:.
Peter Billen wrote:
I would like to ask a question about outputting data as XML. Say I have two
tables:
team(integer id, text name);
player_of_team(integer id, integer team_id, text name); (team_id is FK to
team.id)
I would like to query both tables to get following example XML output:
Hi,
I have been asked to specify a pair of HP PC's to set up a PostGreSQL server
(and backup) for a client. The HP model we are looking at has an AMD Phenom™
Quad Core Processor (9600B). The machines would be running Windows XP Pro (our
clients requirement). Can anyone tell me if PostgreSQL
