Tony Caduto <[EMAIL PROTECTED]> writes:
> I can post the full function if need be, just let me know.
How about the relevant table and index definitions?
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading th
In ./src/test/regress/log/postmaster.log I cannot find
anything regarding the stats collector non-start.
Does it help to send the file (about 72 KB)?
Regards, Christoph
Tom Lane wrote:
>
> Christoph Haller <[EMAIL PROTECTED]> writes:
> > test stats... FAILED
>
> Check the po
Title: RE: [BUGS] solaris 10 with gcc 3.3.2
Tom,
Yeah, I've already fired off a query about this gcc build to the source.
In my case, I downloaded it from www.sunfreeware.com, and, for good measure, I also tried gcc 3.4.2 for solaris 9, on a solaris 10 box, and, indeed, it looks like the
Well, I got my 8.0 RC1 working the same as my 7.4.5 and it is for sure
because of some difference in the SQL engine.
On my 7.4.5 box I had the following in the postgresql.conf file:
enable_seqscan = true (this is the default setting)
7.4.5 had no problems using the indexes with this setting = tr
I have tracked the problem down to the aggregate COUNT function.
In the below code with the count function in the proc the execution time
per 1000 rows of import increases after each commit of 1000.
Please see these screen shots showing the importer running under 7.4.5
and 8.0 rc1
http://www.ams
Title: RE: [BUGS] solaris 10 with gcc 3.3.2
I got a response from Steve (of SunFreeware) and he also has put some info up on the site about regenerating the cleaned-up files.
I've done this with the gcc 3.3.2 for solaris 10, and have now successfully built postgresql rc1.
I haven't tried ex
Bruce Momjian wrote:
> Luojia Chen wrote:
>
>>Hi,
>>
>>Please see my inline reply.
>>
>>Bruce Momjian wrote:
>>
>>>Would you tell use what is on this line?
>>>
>>> /usr/include/sys/siginfo.h:259:
>>
>>ctid_t __ctid; /* contract ID */
>
>
> OK, do a 'grep' and find out what
Hi Tom,
Yes I did a vacuum analyse right away. As a further test I restored
the exact same data on another 7.4.5 server and even without a vacuum
analyse the importer program worked as expected(fast).
I posted some more info including screen shots of the importer running
in verbose mode on
Zsolt Pfiszter <[EMAIL PROTECTED]> writes:
> our enviroment settings:
> postgres# locale
> LANG=hungarian
> LC_CTYPE="hungarian"
> LC_NUMERIC="hungarian"
> LC_TIME="hungarian"
> LC_COLLATE=POSIX
> LC_MONETARY="hungarian"
> LC_MESSAGES="hungarian"
> LC_ALL=
> template1=# select * from pg_namespace
unsubscribe [EMAIL PROTECTED]
Christoph Haller <[EMAIL PROTECTED]> writes:
> In ./src/test/regress/log/postmaster.log I cannot find
> anything regarding the stats collector non-start.
> LOG: could not translate host name "localhost", service "65432" to address:
> Unknown host
> WARNING: could not create listen socket for "l
Christoph Haller <[EMAIL PROTECTED]> writes:
> In ./src/test/regress/log/postmaster.log I cannot find
> anything regarding the stats collector non-start.
Hmm, I'd expect there to be a complaint right at the beginning.
> Does it help to send the file (about 72 KB)?
Off-list please.
The following bug has been logged online:
Bug reference: 1351
Logged by: taufik
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.3.2
Operating system: linux redhat 9
Description:service postgresql start failed
Details:
i having promblem with my posgresql,
13 matches
Mail list logo