Re: [GENERAL] Performance question

2001-09-10 Thread Herbert.Liechti
On Mon, 10 Sep 2001, Tille, Andreas wrote: > Hello, > > I have ported a database from MS SQL Server to PostgreSQL. The database has > 40 tables and 117 indexes which I defined for the same fields as in MS SQL. > I converted the data using some SQL output from MS SQL server and inserted > it with

Re: [GENERAL] "trigger"ing a procedure every X minutes

2001-06-06 Thread Herbert.Liechti
On Wed, 6 Jun 2001, Fran Fabrizio wrote: > > Some thoughts are: > > 1. It would be portable with the database. I don't have to go setting up > crons on the new machine if I move the db. > 2. The cron usually involves writing a shell/perl/whatever script to call > the psql client and pass in SQ

Re: [GENERAL] postgresql on SuSE 7.1 with reiserfs

2001-06-07 Thread Herbert.Liechti
On Thu, 7 Jun 2001, Jose Manuel Lorenzo Lopez wrote: > Hello community, > > anyone experienced problems using postgresql distribution > on SuSE 7.1 with reiserfs??? Yes without any problems. > > I noticed the following problem: > > When creating a table 'tableA' as User A I can not insert in th