Re: PostgreSQL giving jitters to Skypak

On Tue, 24 Aug 2004, Jussi.Mikkola@bonware.com wrote:

> Hi !
>
> I think it would be a good idea to check how they are using indexes, and what
> the structure of the database is. Missing an index or two can affect quite
> much.

As I'm experiencing with a client right now ... schema hurts alot too ...
all of their queries are bigint = int, so they are having to go through
their code and changing it to bigint = int::bigint so that indices are
being used properly ...

  > > Rgs,
>
> Jussi
>
>
>> Dear Josh ,
>>
>> >>http://www.cxotoday.com/cxo/jsp/index.jsp?log=false&file=template1.jsp§
>>
>>> ion_code=1§ion=News&storyid=1383&subsection_code=1&subsection=Business&s
>> >>ource=cxtnl&userid=aspire420@hotpop.com
>> >>    >>
>> >
>> >Can you or someone else in India contact them?   Shridhar?
>> >
>> >  >
>> I would do this and following is the list of questions I would be asking on
>> the same time I would request others to add more ,
>>
>> 1. Vacuum usage
>> 2. postgresql.conf  settings used (I am not a pro in this field)
>> 3. OS used its not clear if PostgreSQL is on non windows platform.
>> 4. I myself am not aware of any consultants in India that can provide
>> PostgreSQL optimization.
>>
>> Others are requested to add more questions I would be calling on 27 August
>> 2004, on the following number
>> 22-28508181
>>
>> Best Regards,
>> Vishal Kashyap
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664